I'm pretty basic when it comes to Excel. How can I change the date format
for the date field that I've placed in my footer? I would like it to show
04-11-06.

Thanks.

Terry S.

hi!

go to.. Format Cells Custom mm-dd-yy

-via135



Terry Sharman Wrote:
I'm pretty basic when it comes to Excel. How can I change the date
format
for the date field that I've placed in my footer? I would like it to
show
04-11-06.

Thanks.

Terry S.


--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=531990

Thanks for the quick response, but this is in the "footer" and it doesn't
seem to work as you wrote....

Terry S.

"via135" wrote:


hi!

go to.. Format Cells Custom mm-dd-yy

-via135



Terry Sharman Wrote:
I'm pretty basic when it comes to Excel. How can I change the date
format
for the date field that I've placed in my footer? I would like it to
show
04-11-06.

Thanks.

Terry S.


--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=531990

Terry Sharman wrote:
I'm pretty basic when it comes to Excel. How can I change the date format
for the date field that I've placed in my footer? I would like it to show
04-11-06.

Thanks.

Terry S.

Go to file page setup then select the header/footer tab.
Click on the custom footer button select the icon
that looks like a little calender. It should place
a variable for date &[Date] in whatever section you
have selected.

gls858

Thanks gls858. I've done that but the format is "dd/mm/yy" and I would like
it to be "dd-mm-yy".

Terry S.

"gls858" wrote:

Terry Sharman wrote:
I'm pretty basic when it comes to Excel. How can I change the date format
for the date field that I've placed in my footer? I would like it to show
04-11-06.

Thanks.

Terry S.

Go to file page setup then select the header/footer tab.
Click on the custom footer button select the icon
that looks like a little calender. It should place
a variable for date &[Date] in whatever section you
have selected.

gls858

Terry

You can effect limited changes to Excel's footer/header date format by adjusting
your short/long date format in Windows Regional and Language Settings.

StartSettingsControl Panel..........follow your nose.


Gord Dibben MS Excel MVP

On Wed, 12 Apr 2006 05:12:02 -0700, Terry Sharman
wrote:

Thanks gls858. I've done that but the format is "dd/mm/yy" and I would like
it to be "dd-mm-yy".

Terry S.

"gls858" wrote:

Terry Sharman wrote:
I'm pretty basic when it comes to Excel. How can I change the date format
for the date field that I've placed in my footer? I would like it to show
04-11-06.

Thanks.

Terry S.

Go to file page setup then select the header/footer tab.
Click on the custom footer button select the icon
that looks like a little calender. It should place
a variable for date &[Date] in whatever section you
have selected.

gls858