View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kevin Vaughn
 
Posts: n/a
Default 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?