Thank you very much. It works!!!

Regards,
User


U¿ytkownik "Biff" napisa³ w wiadomo¶ci ...
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" wrote in message ...
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