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

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

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

Reply to this Message

Anthony - 15 Mar 2006 23:49 GMT

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

> 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 >
[quoted text clipped - 11 lines]
> > list and I was wondering if there was away to perform this task without going
> > to each one individually and adding the zero?

Reply to this Message

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

Sandy

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

Reply to this Message

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.

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

Reply to this Message

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

Signature

Kevin Vaughn

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

Reply to this Message