I have a range of numbers in a column that corresponds with years. I received them from my data source formatted as general. My goal is to turn 2014 into 14. Since they are not formatted as dates my idea was to simply subtract 2000 from each cell. I am trying to use the sub below:

Please Login or Register  to view this content.
The error I am getting is Run-time error ’13’:
Type mismatch

Any Suggestions??