Excel
--
Newfie
"Newfie809" wrote:
Thank you David
Newfie
"David Biddulph" wrote:
If you want to turn them into text strings, either
=0&A1 or
=TEXT(A1,"000000000")
If you want them to be numbers but formatted as 9 digits, Format/ Cells/
Number: 000000000
-
David Biddulph
"Newfie809" wrote in message
...
I have an Excel spreadshee with 16000 Employee Numbers. I need to put a
Zerro in front of each number to have a nine digit 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 digit number or do I have to select each
cell and add it one by one. Thanks.
--
Newfie
|