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. |
#2
|
|||
|
|||
Select the column with the dates, do datatext to columns, click next twice
and under column data format select Date and then MDY or DMY depending on if you are using US or British dates, click finish Regards, Peo Sjoblom "JR" wrote: 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. |
Reply |
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) |