Formating years.

J

jason2444

have a csv file that in one column has years 89-99, 99-04 can I format that
column so that it changes those years to 1989-1999, 1999-2004
 
D

DBsWifeLB

I believe that when you format the cells to the date format you just
need to enter yyyy. For a column that is all in 1900's you would enter
19yy as a custom date entry.
Hope this info helps.
 
M

Miguel Zapico

You can add a new column is Excel with a formula like this:
=IF(LEFT(A1,1)="0","20",19) & LEFT(A1,2) & "-" & IF(MID(A1,4,1)="0","20",19)
& RIGHT(A1,2)
That hardcode the format in your values.
 
J

jason2444

Changed the formula slightly to fit my file.
=IF(LEFT(E2,1)="0","20",19) & LEFT(E2,2) & "-" & IF(MID(E2,4,1)="0","20",19)
 
J

jason2444

one last question in some of the cells it 04+ or 03+ the + meaning to current
year. is there a what to make it display 2004 - 2006
2003 - 2006
 
Top