How can I get Excel to display dates as month-day-year?
On one machine, my dates in Excel display as month-day-year, for example May 27, 2010 displays as 05/27/10. (This machine is Windows XP, in case that's significant. Excel 2003).
When I take that same file and open it on a different machine (Windows 7, also Excel 2003), the same date displays as 27/05/10.
Is this an Excel thing or a Windows thing? How can I fix it so the date displays the way I want it, mm/dd/yy ?
Thanks
When I take that same file and open it on a different machine (Windows 7, also Excel 2003), the same date displays as 27/05/10.
Is this an Excel thing or a Windows thing? How can I fix it so the date displays the way I want it, mm/dd/yy ?
Thanks
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
1. I changed the Regional settings to English (U.S.), then rebooted the machine and re-opened my spreadsheet. The dates still showed up as 14/06/10 instead of 06/14/10
2. I tried to re-format it using the Excel --> Format Cells --> Date --> 03/14/01. No joy.
3. Thanks for the graphic help, cyberkiwi. I then tried to format it using a custom format - m/d/yyyy. That worked.
Thank you very much, cyberkiwi, tevlyn and barryhoudini.