| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert text "20100315" to date format
Hi,
I have some data exported from a system, the date is a text displayed as "20100315" which should read yyyymmdd. I need to convert this text to another date format showing mm/dd/yyyy in text for importing into another system. As the text format yyyymmdd does not contain any "/" or "-" so using text to column will be a difficulty. Please advise how could I handle this. Thanks a lot. Best Regards, Terry |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| retain custom date format "text" when pasting or reformatting data | Excel Discussion (Misc queries) | |||
| Convert numbers to date: "586" to read "May 1986" | Excel Worksheet Functions | |||
| Convert WEEKNUM(date;2) to text "Monday 25th - Sunday 31st Oct" | Excel Discussion (Misc queries) | |||
| how i convert "100" to "hundred"( number to text) in excel-2007 | Excel Worksheet Functions | |||
| Convert text "date" (DDMMMYY) to datetime value of YYYY-MM-DD - ho | Excel Discussion (Misc queries) | |||
Threaded Mode
