View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
User
 
Posts: n/a
Default Empty cell - zero

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