ExcelBanter - HOW DO I DISPLAY ZERO VALUES IN SELECTED CELLS IN EXCEL.

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

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

- - HOW DO I DISPLAY ZERO VALUES IN SELECTED CELLS IN EXCEL. (https://www.excelbanter.com/excel-discussion-misc-queries/41591-how-do-i-display-zero-values-selected-cells-excel.html)

derf

HOW DO I DISPLAY ZERO VALUES IN SELECTED CELLS IN EXCEL.

Richard Neville

Tools-Options-View tab. Check the "Show zero values" box.

"derf" wrote in message
...

Dave Peterson

Put 0's in them?

derf wrote:

--

Dave Peterson

All times are GMT +1. The time now is 07:14 PM.