THANK YOU, THANK YOU, THANK YOU, SO VERY MUCH. Boy so simple and yet I was
having nightmares, again thank you so very much.

"bpeltzer" wrote:

Is your number always eight digits? If so, you can keep the numbers in place
and effect the change with a custom format. Select the list, then Format
Cells, select the Number tab and choose the Custom category. In the text
box, enter 000000000, then click OK.
If the number of digits varies, I'd probably use a formula to create the new
number, as text. If the first number is in A2, then ="0"&A2 should show what
you want, but recognize that it's no longer a number (so, for instance, you
can't add these).

"Anthony" wrote:

Example. I have a number 12345678 I would like to add a zero to the
beginning like for it to reflect 012345678.

I have a hugh list that I need to add a zero to the beginning of the number
list and I was wondering if there was away to perform this task without going
to each one individually and adding the zero?