custom header date formats

[Ron777]

How can I set the date format on a custom header? I know I can use
&[date] to insert the date...the problem is I want the date to display
in a specific format (ex: MMDDYY or MMDDYYYY)

Thanks!

Ron

 

[Otto Moehrbach]

Use something like:
& TEXT(Today(),"d-mmm-yy")
HTH Otto

 

[Ron777]

*Use something like:
& TEXT(Today(),"d-mmm-yy")
HTH Otto
color] *

I tried that, and it works fine in a worksheet cell, but not on
header/footer... :confused

 

[Otto Moehrbach]

Ron
I thought that would work but I found out, as you did, that it doesn't.
I hope someone will take pity on both of us and tell us how. You might try
posting your question again in a different thread. HTH Otto

*Use something like:
& TEXT(Today(),"d-mmm-yy")
HTH Otto
color] *

I tried that, and it works fine in a worksheet cell, but not on a
header/footer...

 

[Peo Sjoblom]

Otto,

I believe it uses the regional setting date system, I believe a macro is the
only
way if you don't want to change that setting..

ActiveSheet.PageSetup.LeftHeader = Format(Now, "d-mmm-yy")

--

Regards,

Peo Sjoblom

Ron
I thought that would work but I found out, as you did, that it doesn't.
I hope someone will take pity on both of us and tell us how. You might try
posting your question again in a different thread. HTH Otto

*Use something like:
& TEXT(Today(),"d-mmm-yy")
HTH Otto
color] *

I tried that, and it works fine in a worksheet cell, but not on a
header/footer...

 

[Otto Moehrbach]

Peo
Thanks for the info. Maybe the OP can use that to achieve what he
wants. Otto

Otto,

I believe it uses the regional setting date system, I believe a macro is the
only
way if you don't want to change that setting..

ActiveSheet.PageSetup.LeftHeader = Format(Now, "d-mmm-yy")

--

Regards,

Peo Sjoblom

Ron
I thought that would work but I found out, as you did, that it doesn't.
I hope someone will take pity on both of us and tell us how. You might try
posting your question again in a different thread. HTH Otto

Otto Moehrbach wrote:
*Use something like:
& TEXT(Today(),"d-mmm-yy")
HTH Otto
color] *

I tried that, and it works fine in a worksheet cell, but not on a
header/footer...