Showing Zero for all blank cells in a range

[ashish128]

Hello All,
I have a range with some cell having no value. I want to convert
these blank cell to zero i.e they should have a numerical value Zero
(0).
Is it possible, how?

 

[Mallycat]

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

 

[ashish128]

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)