Showing Zero for all blank cells in a range

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?
 
M

Mallycat

ashish128 said:
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
 
A

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)
 

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

Top