Quote:
Originally Posted by Newfie809
I have an Excel spreadshee with 16000 Employee Numbers. I need to put a
Zerro in front of each number to have a nine didget number. It can not go at
the back it has to go in front of the number. Is there a formula that would
put the number in front of the 8 didget number or do I have to select each
cell and add it one by one. Thanks.
--
Newfie
|
Try: =0&A1 copied down or =TEXT(A1,"000000000") copied down
assuming first entry is in A1.
You can then copy|paste special Values over the original column.