software

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 gt;
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 =quot;0quot;amp;A2 should show what
you want, but recognize that it's no longer a number (so, for instance, you
can't add these).

quot;Anthonyquot; wrote:

gt; Example. I have a number 12345678 I would like to add a zero to the
gt; beginning like for it to reflect 012345678.
gt;
gt; I have a hugh list that I need to add a zero to the beginning of the number
gt; list and I was wondering if there was away to perform this task without going
gt; to each one individually and adding the zero?


=quot;0quot;amp;A1
if A1 is 123
the formula will disply 0123

Sandyquot;Anthonyquot; wrote:

gt; Example. I have a number 12345678 I would like to add a zero to the
gt; beginning like for it to reflect 012345678.
gt;
gt; I have a hugh list that I need to add a zero to the beginning of the number
gt; list and I was wondering if there was away to perform this task without going
gt; to each one individually and adding the zero?

for example, you have quot;010quot;, but it shows 10. You right click the cell, then
format cell -gt; number-gt;category-gt;custom. And then you put 000 in quot;Typequot;.
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 quot;Text(A1,quot;000quot;)quot; to get it.quot;Anthonyquot; wrote:

gt; Example. I have a number 12345678 I would like to add a zero to the
gt; beginning like for it to reflect 012345678.
gt;
gt; I have a hugh list that I need to add a zero to the beginning of the number
gt; list and I was wondering if there was away to perform this task without going
gt; to each one individually and adding the zero?

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

--
Kevin Vaughnquot;Anthonyquot; wrote:

gt; Example. I have a number 12345678 I would like to add a zero to the
gt; beginning like for it to reflect 012345678.
gt;
gt; I have a hugh list that I need to add a zero to the beginning of the number
gt; list and I was wondering if there was away to perform this task without going
gt; to each one individually and adding the zero?

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

quot;bpeltzerquot; wrote:

gt; Is your number always eight digits? If so, you can keep the numbers in place
gt; and effect the change with a custom format. Select the list, then Format gt;
gt; Cells, select the Number tab and choose the Custom category. In the text
gt; box, enter 000000000, then click OK.
gt; If the number of digits varies, I'd probably use a formula to create the new
gt; number, as text. If the first number is in A2, then =quot;0quot;amp;A2 should show what
gt; you want, but recognize that it's no longer a number (so, for instance, you
gt; can't add these).
gt;
gt; quot;Anthonyquot; wrote:
gt;
gt; gt; Example. I have a number 12345678 I would like to add a zero to the
gt; gt; beginning like for it to reflect 012345678.
gt; gt;
gt; gt; I have a hugh list that I need to add a zero to the beginning of the number
gt; gt; list and I was wondering if there was away to perform this task without going
gt; gt; to each one individually and adding the zero?