| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Formatting Date in Header & Footer
My header & footer was displaying as dd/mm/yyyy and I needed it to be
dd/mm/yy, I tried for ages to change it, checking out the message boards etc. to no avail. Guess what? You change the date format by going to the REGIONAL & LANGUAGE SETTINGS in CONTROL PANEL on your pc. This then changes the way it displays in Excel. Hope this saves others some time. |
|
#2
|
|||
|
|||
|
Thanks Eliza.
Hope it helps others. Gord Dibben Excel MVP On Tue, 15 Mar 2005 12:09:03 -0800, "Eliza" wrote: My header & footer was displaying as dd/mm/yyyy and I needed it to be dd/mm/yy, I tried for ages to change it, checking out the message boards etc. to no avail. Guess what? You change the date format by going to the REGIONAL & LANGUAGE SETTINGS in CONTROL PANEL on your pc. This then changes the way it displays in Excel. Hope this saves others some time. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Incorrect Date formatting | Excel Discussion (Misc queries) | |||
| How do I enter the date last modified in the footer of an Excel d. | Excel Discussion (Misc queries) | |||
| header or footer | Excel Worksheet Functions | |||
| Conditional Formatting (Date vs Number) | Excel Discussion (Misc queries) | |||
| Date in Footer | Excel Worksheet Functions | |||
Linear Mode
