Thread: delete zero's from numbers
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
P Sitaram P Sitaram is offline
external usenet poster
  
Posts: 4
Default delete zero's from numbers

Enter 1 in a spare cell.

Copy the cell, select the desire range and Paste Special|Multiply.

Reply With QuoteReply With Quote