Thread: Excel - Replace blank cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Newsgal Newsgal is offline
external usenet poster
  
Posts: 24
Default Excel - Replace blank cells
How can I get blank cells to display $0 in a spreadsheet where some cells
have data and some are blank. Formatting the range as either the Currency or
Accounting number format does nothing.
--
News Gal
Reply With QuoteReply With Quote