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

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

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

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

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

Sandy


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

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

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.


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

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

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

--
Kevin Vaughn


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

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

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?