Someone gave me a spread sheet that is screwed up.
The account numbers should all be 7 digits long, but the accounts that started with zero have been stripped of all zeroes .. he is an example
0111111 is now 111111
0011111 is now 11111
0001111 is now 1111
Is there a way of inserting the leading zeroes back into the cells?