Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i convert text to date (mm/yy text to mm/dd/yyyy date)?
the problem is the way the text date is currently set up: mm/yy
i now need to track the day as well so i need to change the above to mm/dd/yyyy when i try to use "text to columns" all of the MDY, YDM, etc. options i can't get it to display the way i need it to (it can have "01" for all of the days up to this point but i need to start tracking days from this point on) example: i have "12/06" in text format in a cell. when i use text to columns it interprets this as either 06/12/2007 or 12/06/2007--i want it to interpret this as 12/01/2006. thanks in advance |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i convert text to date (mm/yy text to mm/dd/yyyy date)?
One way is to use a formula to convert your text to a date. Eg:
=date(right(a1,2),left(a1,2),1) Copy down your column. -- Regards, Fred "lindsey" wrote in message ... the problem is the way the text date is currently set up: mm/yy i now need to track the day as well so i need to change the above to mm/dd/yyyy when i try to use "text to columns" all of the MDY, YDM, etc. options i can't get it to display the way i need it to (it can have "01" for all of the days up to this point but i need to start tracking days from this point on) example: i have "12/06" in text format in a cell. when i use text to columns it interprets this as either 06/12/2007 or 12/06/2007--i want it to interpret this as 12/01/2006. thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert text "date" (DDMMMYY) to datetime value of YYYY-MM-DD - ho | Excel Discussion (Misc queries) | |||
convert date mm/dd/yyyy to dd/mm/yyyy | Excel Worksheet Functions | |||
Help: How do I convert a text date into a real date format | Excel Worksheet Functions | |||
How do I convert a date&time (yyyy-mm-dd hh:mm:ss) to date only? | Excel Worksheet Functions | |||
How to convert date to text | Excel Discussion (Misc queries) |