Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting Text to Date using "Text to Columns"
Hi all,
I have a few columns of date in excel which is imported from external data source. It is shown as text in Excel. Some sample of the data are like - 240708 (which is 24th July 2008) - 10208 (which is 1 Feb 2008) However, when I use the Text to Columns/Date(DMY) function to convert them date, the following results is given - 240708 -- 24/07/08 (correct) - 10208 -- 2/10/08(INCORRECT) I tried with Text to Columns/Date(MDY), then - 240708 -- 240708 (nothing happen) - 10208 -- 1/02/08(correct) Is there any method in Excel I can use to convert this text to date? They come in a mix of 5 and 6 digits. Please help... Thank you. -- Kahoko Tsuki. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting a text form of "=Sheet2!A1" into a reference formula | Excel Discussion (Misc queries) | |||
Formating numbers &"Text" to appear as currency &"Text" in formula | Excel Discussion (Misc queries) | |||
Excel should support a proper inverse to "Text to columns" | Excel Discussion (Misc queries) | |||
Splitting text, like "Text to columns", but as a formula | Excel Discussion (Misc queries) | |||
Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) |