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?