ExcelBanter - Excel - Replace blank cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Excel - Replace blank cells (https://www.excelbanter.com/excel-discussion-misc-queries/107974-excel-replace-blank-cells.html)

Newsgal

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

Bob Umlas

Excel - Replace blank cells

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

All times are GMT +1. The time now is 02:21 AM.