I have several workbooks where numbers have leading zeros. I.e SS last 4 (0789). I am trying to find VBA on the worksheet level, to force excel to keep leading zeros. I have found several codes to keep leading zeros, but they use a module. I am trying to find worksheet level code that automatically keeps leading zeros. If anyone can lead me in the right direction, it will be appreciated. Manually adding a apostrophe, is quite a pain if you have several files/workbooks.