View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob I Bob I is offline
external usenet poster
 
Posts: 2,819
Default how to replace all # to blank.

R-click, Clear contents?

John wrote:

In my worksheet, there are some of the box are fill with color, the arther
all are numbers. so, how to use a formula or macro to replace all numbers to
blank. and just keep the color box.