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

"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

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

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 your
satisfaction, then copy the range and paste as value i.e. paste special.


Regards.
Tejas Shah


--
TEJAS SHAH
------------------------------------------------------------------------
TEJAS SHAH's Profile: http://www.excelforum.com/member.php...o&userid=33764
View this thread: http://www.excelforum.com/showthread...hreadid=535340

You're welcome. Thanks for the feedback!

Biff

"User" wrote in message
...
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

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


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 your
satisfaction, then copy the range and paste as value i.e. paste special.


Regards.
Tejas Shah


--
TEJAS SHAH
------------------------------------------------------------------------
TEJAS SHAH's Profile: http://www.excelforum.com/member.php...o&userid=33764
View this thread: http://www.excelforum.com/showthread...hreadid=535340