How can I have a zero in a blank cell at start up

M

Mike Davis

I would like to format a spreadsheet with a zero in all the cells that does
not have data in them.

Is this possible without a formular?
 
D

David McRitchie

So should an empty sheet should display 65536 x 256 cells with zeros?
That might be about 42K sheets of paper (84 reams). with 50 rows x 8 columns per page.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
How to display zero value in blank fields of Cross Tab query 0
Excel 2013: How to ensure a cell is not left blank by users? (Not using VBA) 0
Dealing with a Pivot Table (when I don't want to) 0
Word macro that can call cells out of Excel for a find and replace 0
Have 4 email addresses Want to auto forward all in one of them 0
Need Help with a VBA subroutine 0
Merging from an Excel file with graphics 1

Top