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

[And the word is "digit", not "didget".]
--
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 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