Showing Zero for all blank cells in a range

  • Thread starter Thread starter ashish128
  • Start date Start date
A

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?
 
ashish128 said:
Is it possible, how?
Click to expand...
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
 
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)
 
Back
Top