| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Default date formats
In Excel 2002, dates entered in a worksheet as "dd/mm" default to a custom
format of "d-mmm". For example, 4/26 shows as 26-Apr in the worksheet cell even though it is shown as 4/26/2005 in the Formula Bar. I want them to default to "mm/dd/yyyy". In the Regional settings, the default short date format is shown as "dd/mm/yyyy". Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing Cell formats to date fields automatically | Excel Worksheet Functions | |||
| excel date formats changed | Excel Worksheet Functions | |||
| US vs UK date and time formats | Excel Discussion (Misc queries) | |||
| Seed date formats to different year in different cells | Excel Discussion (Misc queries) | |||
| Excel Default date for date format | Excel Discussion (Misc queries) | |||
Threaded Mode
