=IF(LEFT(A1)="2",20&MID(A1,2,2),LEFT(A1,2))*1

Vaya con Dios,
Chuck, CABGx3



"Curalice" wrote in
message ...

In Col A I have number strings that indicate the year in either the
first 2 or the first 3 numbers
204359687456 - 2004 year
982356441445 - 1998 year
I can use MID and LEFT to get 04 and 98 in Col B, but I want to add the
'prefix" of 20 or 19 so that the list will sort in the Worksheet column
and Pivot Table row.
Any help is appreciated.


--
Curalice
------------------------------------------------------------------------
Curalice's Profile:
http://www.excelforum.com/member.php...o&userid=28600
View this thread: http://www.excelforum.com/showthread...hreadid=502725