Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How change the date format in the excel footer to dd mmm yy?
To stop confusion betweem US and European numerical date formats ie US
06/07/05 means 07 Jun'05, whereby European means 06 Jul'05. Regards, John Ellis |
#2
|
|||
|
|||
Hi John
You can do it with code if you want Here is example http://www.rondebruin.nl/print.htm#Saved If you need more help post back -- Regards Ron de Bruin http://www.rondebruin.nl "John Ellis" <John wrote in message ... To stop confusion betweem US and European numerical date formats ie US 06/07/05 means 07 Jun'05, whereby European means 06 Jul'05. Regards, John Ellis |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
date format in excel not in line with control panel regional setti | Excel Discussion (Misc queries) | |||
How to change the footer only, on multiple worksheets in Excel? | Excel Worksheet Functions | |||
EXCEL - Please add a date format - yyyy mmm dd (mmm being letters | Excel Worksheet Functions | |||
Imported Date & Time format with calcs. managed in excel from imrp | Excel Worksheet Functions | |||
Converting a date in Excel 2002 to a Year/Quarter format | Excel Worksheet Functions |