| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
My date format is not as the template states
Everytime I type in my date ie. aug3 it will then come in a format as
08/01/2003 or if I type in Jul22 it will show as 07/01/2022. No matter what format I select for the cell it takes the number that I type as the year. I have tried detect and repair and have uninstalled and reinstalled office. I have it running on XP and prior to this week this function was not an issue. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help - Date Format | Excel Worksheet Functions | |||
| Compare dates (one cell not in date format) | Excel Discussion (Misc queries) | |||
| How do I keep the date from changing format in a mail merge? | Excel Discussion (Misc queries) | |||
| Excel enters date as a text format | Excel Discussion (Misc queries) | |||
| Opening a csv file with US date format on a Australian PC | Excel Discussion (Misc queries) | |||
Threaded Mode
