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