how do i convert text to date (mm/yy text to mm/dd/yyyy date)?

G

Guest

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
 
F

Fred Smith

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do i change text format date to date (i.e., mm/yy to mm/dd/yyy 1
change DD/MM/YY to MM/DD/YY 6
Entering dates into cells as mm/yy or yy 4
Change from mm/dd/yy to yy/mm> 3
Convert date to text without changing format dd/mm/yy 3
Returning the month (mmm) from cell in date format dd/mm/yyyy 1
Help with date format mm/dd/yyyy vs. dd/mm/yyyy 3
reformat dates to yyyy/mm/dd 5

Top