Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change text to date
I have a column of cells with dates stored as text i.e.
041012 and I would like to convert this to 12/10/04 (dd/mm/yy) how do I do this, please |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change text to date
Hi
Select the cells. Go menu Data Text to columns. Go "Next" until you're in the wizard's part 3, there select format Date, MDY (or DMY is that's what you have) and click Finish. HTH. Best wishes Harald "Gerrym" skrev i melding ... I have a column of cells with dates stored as text i.e. 041012 and I would like to convert this to 12/10/04 (dd/mm/yy) how do I do this, please |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change text to date
Hi. Assuming the text is in "A1", try this in "B1",
=RIGHT(A1,2)&"/"&MID(A1,3,2)&"/"&LEFT(A1,2). You end up with a date, but u may have to copy and paste it special to get rid of the formulas. "Gerrym" wrote: I have a column of cells with dates stored as text i.e. 041012 and I would like to convert this to 12/10/04 (dd/mm/yy) how do I do this, please |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CHANGE TEXT DATE TO NUMERIC DATE | Excel Worksheet Functions | |||
How can I change NOW() to a date when combined with text? | Excel Worksheet Functions | |||
Change text to date | Excel Discussion (Misc queries) | |||
how do i change text format date to date (i.e., mm/yy to mm/dd/yyy | Excel Discussion (Misc queries) | |||
CHANGE TEXT TO DATE FORMAT | Excel Discussion (Misc queries) |