I have a database that is sorted and imported into excel for charting
purposes. I have all the data there but need to pull out the first 2 numbers
of a field to create a year. Here is an example of the data I am importing:

93h00151615 (would be 1993)
10j56465665 (would be 2010)

I am using this function to accomplish this in another colume:

if(left(b2,2)<11,20&left(b2,2),19&left(b2,2)

This always uses the default because it doesn't reconize the first two
characters as letters. I have reformated the cells but it doesn't work.

Thank you for your help.