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

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