View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Graham at Mac's Graham at Mac's is offline
external usenet poster
 
Posts: 1
Default adding extra digits to columns

I have a column of numbers (isbn for books) which should all have 10 digits.
Somewhere in the copying process some of the numbers have not been formatted
as text and have dropped the zero from the beginning of the number. I need to
add a zero to the beginning of all the nine digit numbers in the column. How
do I achieve this ?