View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] michael.holohan@synovate.com is offline
external usenet poster
 
Posts: 1
Default Display Zero's (0) in blank cells

I need to format an excel worksheet to show "Zero" in cells that are
blank.

I understand how to show them when you type in Zero (0) but cannot get
it to show Zero when the cell is blank.

Any ideas would be very helpfull