| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Showing Zero for all blank cells in a range
Thanks mallycat,
But I also found another option which is 1. Enter Zero in any other cell 2. Copy this value from cell 3. Select Range 4 Do Paste Special and Choose Add 5. Wow , It happens Please Conside this thread as Closed (as i got my answer) Mallycat wrote: ashish128 Wrote: Is it possible, how? Blanks and Zeros are not the same thing. You will need to enter 0s in the cells. The best way to do this is 1) select the entire range that contains the spaces (including any formula and data) 2) press F5 SPECIAL and select BLANKS 3) type 0 and press SHIFT ENTER Matt -- Mallycat ------------------------------------------------------------------------ Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514 View this thread: http://www.excelforum.com/showthread...hreadid=553523 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Simple Sumproduct of 2 Columns, with some blank cells in range | Excel Discussion (Misc queries) | |||
| Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
| Counting blank cells until value is reached | Excel Worksheet Functions | |||
| How can I replace a range of blank cells with a 0 | Excel Discussion (Misc queries) | |||
| Counting blank and filled cells within a range. | Excel Discussion (Misc queries) | |||
Hybrid Mode
