you would have to place a 0 in the blankc - edit/goto Special, Blanks, then
ctrl/enter a 0.
Truly blank cells won't display anything.

"Newsgal" wrote in message
...
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