Thread: Excel
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Newfie809 Newfie809 is offline
external usenet poster
 
Posts: 61
Default Excel

I have an Excel spreadshee with 16000 Employee Numbers. I need to put a
Zerro in front of each number to have a nine didget number. It can not go at
the back it has to go in front of the number. Is there a formula that would
put the number in front of the 8 didget number or do I have to select each
cell and add it one by one. Thanks.
--
Newfie