| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Replace cells with blank | Excel Worksheet Functions | |||
| blank cells with auto fill in excel | Excel Worksheet Functions | |||
| Excel inserted 0's in cells linked to blank cells | Excel Discussion (Misc queries) | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| Why does the blank cells blink black and white on my excel spread. | Excel Discussion (Misc queries) | |||
Linear Mode
