Home |
Search |
Today's Posts |
#1
|
|||
|
|||
excel is changing date format
In regional settings I have short date = yyyy-MM-dd. When I type any date for example 2005-05-18 excel change it to 18-05-05. How can I fix this? -- hubbo |
#2
|
|||
|
|||
Format - Cells - Date - Locale - English (United States) and select the
format you want. "hubbo" wrote: In regional settings I have short date = yyyy-MM-dd. When I type any date for example 2005-05-18 excel change it to 18-05-05. How can I fix this? -- hubbo |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I stop excel automatically changing my date to 2005? | Excel Discussion (Misc queries) | |||
how to merge a date file into an excel format | Excel Discussion (Misc queries) | |||
How do I change the default date format in an Excel Footer | Setting up and Configuration of Excel | |||
Date issue between Windows and Macintosh version | Excel Discussion (Misc queries) | |||
Auto date changing in Excel is maddening | Charts and Charting in Excel |