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