Is there any way to change the date format of header from [mm/dd/YYYY] to [YYYY/mm/dd]?
※The date format in header was decided by OS's setting。。。But I cant change the OS setting by extension。
I found Advanced Excel has a action called [Worksheet_SetHeader], and can post the formatted date to solve this problem.
Hi
Can you please share more on how you write the headers to the file?
Hanno
I wasnt write the header directly，but creat a template file with a header.
Hi,
check this post similar issue. I hope this will work for you.
Thanks,
Amit
Thank you for your response,
i want to know the way to set the format of header's date,not the cell.
Could you please try to attach an oml file if possible?
Gayatri
Hello 王 路
If my understanding is right, Do you want to add Date with the requested format you want ??
If so then we can not add few special character in the file name.Please find the screenshot for better reference.