Workbook_BeforePrint (Date format)
Hi all,
I need a help about format of date. For current coding, i use
.CenterFooter = "&D"
where the format of the date will be default as 30/7/2008. I need to make it as 30-Jul-2008 because this data might be send to America and it is easier to have this (dd-Mmm-yyyy) format to avoid any misunderstanding of the date.
I tried
.CenterFooter = "&Format(Now(), dd-Mmm-yyyy)"
but as the result, it appeared as "filename.xlsormat(Now(), dd-Mmm-yyyy)". Please help me. It seems like easy, but i didnt know the right code to type.
|
