Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting to Dates
Hi there,
I have inherited a worksheet whereby dates have been recorded in the following way: 311007 for 31st October 2007 11107 for 1st November 2007 etc. I now need to convert these cells into a date format so I can sort the data and perform calculations. I'd be grateful for any suggestions on how I can do this. Paul |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
converting Dates | Excel Worksheet Functions | |||
Converting Julian Dates to regular dates | Excel Worksheet Functions | |||
Converting Dates | Excel Worksheet Functions | |||
Converting Dates | Excel Worksheet Functions | |||
Converting dates | New Users to Excel |