| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date in wrong format
I have a cell that is in date format. However it is in the wrong format. What
shows as 7/11/2001 really is supposed to be 2007/11/01. What shows as 7/12/2005 really should be 2007/12/05. Is there a formula I can use to convert these. I dont care if the result is a date, text or numeric formattted cell so long as 7/11/2001 reads as 2007/11/01 (11/01/2007) would be acceptable as well. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date enters wrong #'s | New Users to Excel | |||
| Wrong date format in header | Excel Discussion (Misc queries) | |||
| date entered wrong or not as a date | Excel Worksheet Functions | |||
| YYYY format displaying wrong date | Excel Discussion (Misc queries) | |||
| Wrong date on my posts. | Excel Discussion (Misc queries) | |||
Threaded Mode
