Is there away to add a zero to the beginning of number string?

[Guest]

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?

 

[Guest]

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

 

[Guest]

="0"&A1
if A1 is 123
the formula will disply 0123

Sandy

 

[Guest]

for example, you have "010", but it shows 10. You right click the cell, then
format cell -> number->category->custom. And then you put 000 in "Type".
Then click OK. You will see 010 instead of 10.

But remember, it is still a number instead of text. If you want text, you
need to use function "Text(A1,"000")" to get it.

 

[Guest]

You could format the cells. Select the cells in question, Format cells
custom 000000000 (9 0s in this case.)

 

[Guest]

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