custom header date formats

  • Thread starter Thread starter Ron777
  • Start date Start date
R

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 said:
*Use something like:
& TEXT(Today(),"d-mmm-yy")
HTH Otto
color] *
Click to expand...

I tried that, and it works fine in a worksheet cell, but not on
header/footer... :confused
 
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
Ron777 > said:
Otto said:
*Use something like:
& TEXT(Today(),"d-mmm-yy")
HTH Otto
color] *
Click to expand...

I tried that, and it works fine in a worksheet cell, but not on a
header/footer... :confused:
Click to expand...
 
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

Otto Moehrbach said:
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
Ron777 > said:
Otto said:
*Use something like:
& TEXT(Today(),"d-mmm-yy")
HTH Otto
color] *
Click to expand...

I tried that, and it works fine in a worksheet cell, but not on a
header/footer... :confused:
Click to expand...
Click to expand...
 
Peo
Thanks for the info. Maybe the OP can use that to achieve what he
wants. Otto
Peo Sjoblom said:
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

Otto Moehrbach said:
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
Ron777 > said:
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... :confused:
Click to expand...
Click to expand...
Click to expand...
 
Back
Top