Converting a cell value

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I have a worksheet that is imported from another application. One column
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.
.

Relevant Pages

  • Re: OT: Drop dead, GM (Reading a VIN)
    ... After seeing some of you surprised that your "American" cars were ... How to read a Vehicle Identification Number ... 1st digit: Shows where the vehicle was manufactured. ...
    (rec.arts.tv.soaps.abc)
  • Re: OT: Drop dead, GM (Reading a VIN)
    ... After seeing some of you surprised that your "American" cars were ... How to read a Vehicle Identification Number ... 1st digit: Shows where the vehicle was manufactured. ... Now I know for sure our 3 American vehicles and boat trailers and horse trailer were manufactured in the US. ...
    (rec.arts.tv.soaps.cbs)
  • Re: OT: Drop dead, GM (Reading a VIN)
    ... After seeing some of you surprised that your "American" cars were ... How to read a Vehicle Identification Number ... 1st digit: Shows where the vehicle was manufactured. ...
    (rec.arts.tv.soaps.cbs)
  • Re: you really couldnt make it up.
    ... postcode of the maker, ... Not if the vehicle was first registered before Sept 1st 2001. ... How many times do I have to repeat this? ... Still failed on digit size. ...
    (uk.rec.motorcycles)
  • Re: Converting a cell value
    ... If we assume the OP has not modified the normal break point for determining the century in his Windows regional setting, then this shorter formula can be used... ... involves a Model Year of a vehicle and the last two digits of the year is ... this column of 1 or two digit numbers to the correct model year. ...
    (microsoft.public.excel.worksheet.functions)