 |
 |
Excel v.X date format?!
|
|
|
|
|
Senior User
Join Date: Aug 2002
Location: London, UK
Status:
Offline
|
|
arrrgghh, this is driving me nuts.
I have my OS set to Day/Month/Year format, but Excel ALWAYS goes to Month/Day/Year format. I've searched the MS support pages but to no avail.
Does anyone know how to change the Excel default date format to D/M/Y?
|
|
iMac, Intel Core-Duo 2GHz, 2GB, 250GB, OS X 10.4
PowerBook 12", 867MHz, 640MB, 60GB, OS X 10.4
iMac G3, 333MHz, 288MB, 6GB, OS X 10.3
iPods: 3G iPod, 1G mini, 1G shuffle, 2G nano
|
| |
|
|
|
|
|
|
|
Mac Elite
Join Date: May 2001
Location: Manchester, UK
Status:
Offline
|
|
In my experience, this is a random event in Excel v.X. Sometimes it's OK and other times not. Most frustrating.
|
|
|
| |
|
|
|
|
|
|
|
Fresh-Faced Recruit
Join Date: Feb 2003
Status:
Offline
|
|
I'm facing the same problem too... Previously it managed to saty at Day/Month/Year format..but now its revert to Month/Day/Year format...Damn bloody irritating man... 
|
|
|
| |
|
|
|
|
|
|
|
Junior Member
Join Date: Oct 2002
Location: Sydney, Australia
Status:
Offline
|
|
Originally posted by nbnz:
arrrgghh, this is driving me nuts.
I have my OS set to Day/Month/Year format, but Excel ALWAYS goes to Month/Day/Year format. I've searched the MS support pages but to no avail.
Does anyone know how to change the Excel default date format to D/M/Y?
That is weird, that it is not working for you, the date format IS based on the operating system. According to the Excel help -
Options you select in the International pane in System Preferences determine the default format for the current date and time and the characters recognized as date and time separators — for example, the colon ( : ) and slash (/) on United States-based systems.
On my system entering 2/2/03 becomes a custom cell with dd/mm/yyyy formatting as I have Leading zero for day, Leading zero for month and show century all selected. If you want you can then change it to a date cell with dd/mm/yyyy formatting but this extra step is not really necessary.
Hope this helps.
Edit: tidy up only
(Last edited by teknologika; Oct 14, 2003 at 07:38 PM.
)
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
 
|
|
|
Forum Rules
|
|
|
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
|
HTML code is Off
|
|
|
|
|
|
|
|
|
|
|
|
|
Top
