| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
How can I have a zero in a blank cell at start up
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? |
|
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
How can I have a zero in a blank cell at start up
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. --- HTH, David McRitchie, Microsoft MVP - Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Mike Davis" <Mike wrote in message ... 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| insert date | Excel Worksheet Functions | |||
| If cell is blank, then cell is red | New Users to Excel | |||
| Look for change next blank cell in Range | Excel Worksheet Functions | |||
| conditional formating for a blank cell | Excel Discussion (Misc queries) | |||
| VLookup resulting in a blank cell... | Excel Worksheet Functions | |||
Hybrid Mode
