Empty cell -> zero

[User]

Hi,

I've got an Excel file where some cells include zeros
and some are empty instead of including zero.
I need to have zeros in all empty cells.
How to do it for all cells in a sheet?

I tried to use a "special copy" - without success.
I also tried to change them using Edit from the menu
but the empty cells are not found.

I use Excel97.
There are no formulas, just numbers in the sheet.

Please help me. It's urgent.

Regards,
User

 

[Biff]

Hi!

Hit function key F5
Click the Special button
Select blanks
OK

This will select all empty cells in the USED RANGE.

Enter a 0 in the formula bar then press CTRL ENTER.

Biff

 

[User]

Thank you very much. It works!!!

Regards,
User

Hi!

Hit function key F5
Click the Special button
Select blanks
OK

This will select all empty cells in the USED RANGE.

Enter a 0 in the formula bar then press CTRL ENTER.

Biff

 

[TEJAS SHAH]

Hi,

Try this out.

suppose a2 is blank. write a given below formula is cel b2

=IF(ISBLANK(A2)=TRUE,0,A2)

Drag this formula till the cell you require. If the result is upto you
satisfaction, then copy the range and paste as value i.e. paste special


Regards.
Tejas Sha

 

[Biff]

You're welcome. Thanks for the feedback!

Biff

Thank you very much. It works!!!

Regards,
User

 

[User]

Hi,

Thanks for your advice.
As you know Biff sent a solution which works
and because it was urgent I used his method.

However I'll try your method when I have time.

Regards
User