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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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).
 
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.
 
You could format the cells. Select the cells in question, Format cells
custom 000000000 (9 0s in this case.)
 
THANK YOU, THANK YOU, THANK YOU, SO VERY MUCH. Boy so simple and yet I was
having nightmares, again thank you so very much.
 
Back
Top