H

#### Hawk

involves a Model Year of a vehicle and the last two digits of the year is

imported and leading zeros are deleted. That means that I have a column with

single digit numbers 0 through 8 representing 2000 through 2008. I also have

a few two digit numbers...98, 99, 93, etc., representing 1998, 1999, 1993

model years of vehicles. I am trying to come up with a formula to convert

this column of 1 or two digit numbers to the correct model year. If the cell

has a 0 through 9 in it, I want it to convert to 2000 to 2009. If it has a

two digit number of anykind (XX), I want it to convert to 19XX. I just can't

figure out what the formula would be to do this and all kinds of searching

hasn't led me anywhere. Thanks.