View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default Block deleting all zeros at once.

Use Find and Replace, replacing "0" with nothing. Be sure to select the
"Match entire cell contents" option.

--
Jim Rech
Excel MVP