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