I am getting a column of data from another code and trying to convert it to the 4 digit year number. The data is in a format such that the left to characters are the 2 digit year number, example 150813 is 2015. I copy the column from the other code and place it in column A in excel. In column B, I use this formula: =20&LEFT(A1,2). Downstream formulas don't work unless I copy, paste values, then correct the "number stored as text" error. Is there an easier way? ( I already made sure the cell format was "number.") Thanks!