software

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


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.--
DBsWifeLB
------------------------------------------------------------------------
DBsWifeLB's Profile: www.excelforum.com/member.php...oamp;userid=10802
View this thread: www.excelforum.com/showthread...hreadid=522288You can add a new column is Excel with a formula like this:
=IF(LEFT(A1,1)=quot;0quot;,quot;20quot;,19) amp; LEFT(A1,2) amp; quot;-quot; amp; IF(MID(A1,4,1)=quot;0quot;,quot;20quot;,19)
amp; RIGHT(A1,2)
That hardcode the format in your values.
---

quot;jason2444quot; wrote:

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

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

on a cell containing 99 - 06 it is coming up with 1999 - 20 how do I get it
to add the 06

quot;Miguel Zapicoquot; wrote:

gt; You can add a new column is Excel with a formula like this:
gt; =IF(LEFT(A1,1)=quot;0quot;,quot;20quot;,19) amp; LEFT(A1,2) amp; quot;-quot; amp; IF(MID(A1,4,1)=quot;0quot;,quot;20quot;,19)
gt; amp; RIGHT(A1,2)
gt; That hardcode the format in your values.
gt; ---
gt;
gt; quot;jason2444quot; wrote:
gt;
gt; gt; have a csv file that in one column has years 89-99, 99-04 can I format that
gt; gt; column so that it changes those years to 1989-1999, 1999-2004

Add quot;amp; RIGHT(E2,2)quot; to the end, it was trimmed by the mail.

quot;jason2444quot; wrote:

gt; Changed the formula slightly to fit my file.
gt; =IF(LEFT(E2,1)=quot;0quot;,quot;20quot;,19) amp; LEFT(E2,2) amp; quot;-quot; amp; IF(MID(E2,4,1)=quot;0quot;,quot;20quot;,19)
gt;
gt; on a cell containing 99 - 06 it is coming up with 1999 - 20 how do I get it
gt; to add the 06
gt;
gt; quot;Miguel Zapicoquot; wrote:
gt;
gt; gt; You can add a new column is Excel with a formula like this:
gt; gt; =IF(LEFT(A1,1)=quot;0quot;,quot;20quot;,19) amp; LEFT(A1,2) amp; quot;-quot; amp; IF(MID(A1,4,1)=quot;0quot;,quot;20quot;,19)
gt; gt; amp; RIGHT(A1,2)
gt; gt; That hardcode the format in your values.
gt; gt; ---
gt; gt;
gt; gt; quot;jason2444quot; wrote:
gt; gt;
gt; gt; gt; have a csv file that in one column has years 89-99, 99-04 can I format that
gt; gt; gt; column so that it changes those years to 1989-1999, 1999-2004

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

quot;Miguel Zapicoquot; wrote:

gt; Add quot;amp; RIGHT(E2,2)quot; to the end, it was trimmed by the mail.
gt;
gt; quot;jason2444quot; wrote:
gt;
gt; gt; Changed the formula slightly to fit my file.
gt; gt; =IF(LEFT(E2,1)=quot;0quot;,quot;20quot;,19) amp; LEFT(E2,2) amp; quot;-quot; amp; IF(MID(E2,4,1)=quot;0quot;,quot;20quot;,19)
gt; gt;
gt; gt; on a cell containing 99 - 06 it is coming up with 1999 - 20 how do I get it
gt; gt; to add the 06
gt; gt;
gt; gt; quot;Miguel Zapicoquot; wrote:
gt; gt;
gt; gt; gt; You can add a new column is Excel with a formula like this:
gt; gt; gt; =IF(LEFT(A1,1)=quot;0quot;,quot;20quot;,19) amp; LEFT(A1,2) amp; quot;-quot; amp; IF(MID(A1,4,1)=quot;0quot;,quot;20quot;,19)
gt; gt; gt; amp; RIGHT(A1,2)
gt; gt; gt; That hardcode the format in your values.
gt; gt; gt; ---
gt; gt; gt;
gt; gt; gt; quot;jason2444quot; wrote:
gt; gt; gt;
gt; gt; gt; gt; have a csv file that in one column has years 89-99, 99-04 can I format that
gt; gt; gt; gt; column so that it changes those years to 1989-1999, 1999-2004