how do i change text format date to date (i.e., mm/yy to mm/dd/yyy

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
 

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 convert text to date (mm/yy text to mm/dd/yyyy date)? 1
change DD/MM/YY to MM/DD/YY 6
Change from mm/dd/yy to yy/mm> 3
Entering dates into cells as mm/yy or yy 4
Convert date to text without changing format dd/mm/yy 3
dd/mm/yy if i change to some other format 2
Date Format Not Responding to MM/DD/YY 2
dd/mm/yyy date format 3

Top