View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
gls858 gls858 is offline
external usenet poster
 
Posts: 209
Default changing cell contents based on a condition

Mike wrote:
For all cells in a column, E2 - E20, that contain a value of 0, how can you
change the value to a space while making no changes to cells containg a value
0?


Find and replace? Select the cells find 0 change to blank

gls858