| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
date confusion
general question here guys, I get a report that is in CSV form on a weekly
basis that inludes dates. Some of the data has the date format reversed. i.e. 02/01 instead of 01/02. I am ok with the logic of sorting this issue BUT, sometimes the data transforms into a number. i.e. 49025. why should this be? how can I convert it back to a "real" date.? TIA any ideas |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| date confusion | New Users to Excel | |||
| MDI Confusion | Excel Discussion (Misc queries) | |||
| Sorting pivot tables - text / date confusion | Excel Discussion (Misc queries) | |||
| Confusion..... | Excel Discussion (Misc queries) | |||
| Date vs h:mm:ss confusion | New Users to Excel | |||
Threaded Mode
