Excel

  • Thread starter Thread starter Newfie809
  • Start date Start date
N

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.
 
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

[And the word is "digit", not "didget".]
 
Thank you David

I know that the spelling of diget was wrong but I was talking to someone
else at my desk and forgot to correct it before I sent it. Thanks
--
Newfie


David Biddulph said:
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

[And the word is "digit", not "didget".]
--
David Biddulph

Newfie809 said:
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.
Click to expand...
Click to expand...
 
Back
Top