Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i change text format date to date (i.e., mm/yy to mm/dd/yyy
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 change text format date to date (i.e., mm/yy to mm/dd/yyy
See answer to your first question.
-- 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 date + time text format to date format | Excel Worksheet Functions | |||
Concatenating a Text and a Date without losing orginal Date Format | Excel Discussion (Misc queries) | |||
Help: How do I convert a text date into a real date format | Excel Worksheet Functions | |||
CHANGE TEXT TO DATE FORMAT | Excel Discussion (Misc queries) | |||
how do I format cells to change date and time to just date | Excel Discussion (Misc queries) |