View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ENFGDC4S ENFGDC4S is offline
external usenet poster
 
Posts: 5
Default adding leading zero in Excel

How do I add zeros to numbers in a cell? ex: R1,R12,R152 to R001,R012,R152
This needs to be done in many cells. Thanks