Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Date formats
I received a file with dates as follows 08011944 or August 1, 1944 and I need
to convert it to a true date format 8/1/1944 to use it in other files. I can't simply format it as a date as it isn't recognized as such. Any help in how to convert would be appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reading Date Formats e.g 20050801 (yyyy/mm/dd) | Excel Discussion (Misc queries) | |||
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) |