Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Converting Dates after Import
I have imported employee data from an AS400. The text for dates import as
"1012008" for 01/01/08 or 12012008 for 12/01/08. Is it possible to write a formula to insert the "/" for 4 spaces from the left and again at 6 spaces from the left. I need to be able to make these usable dates without speinding a lot of time. Other suggestions for converting these to a workable date would be appreciated. Thank you for your help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
converting Dates | Excel Worksheet Functions | |||
Converting to Dates | Excel Discussion (Misc queries) | |||
Text Import Wizard, Step 3 (converting .tsv file to Excel) | Excel Worksheet Functions | |||
Converting Julian Dates to regular dates | Excel Worksheet Functions | |||
Converting Dates | Excel Worksheet Functions |