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

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