Empty cell -> zero

  • Thread starter Thread starter User
  • Start date Start date
U

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
 
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
 
Thank you very much. It works!!!

Regards,
User


U¿ytkownik "Biff said:
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
Click to expand...
 
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
 
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
 
Back
Top