software

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 quot;special copyquot; - 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,
UserHi!

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

quot;Userquot; gt; wrote in message
...
gt; Hi,
gt;
gt; I've got an Excel file where some cells include zeros
gt; and some are empty instead of including zero.
gt; I need to have zeros in all empty cells.
gt; How to do it for all cells in a sheet?
gt;
gt; I tried to use a quot;special copyquot; - without success.
gt; I also tried to change them using Edit from the menu
gt; but the empty cells are not found.
gt;
gt; I use Excel97. There are no formulas, just numbers in the sheet.
gt;
gt; Please help me. It's urgent. :-)
gt;
gt; Regards,
gt; User
gt;
Thank you very much. It works!!!

Regards,
UserU¿ytkownik quot;Biffquot; gt; napisa³ w wiadomo¶ci ...
gt; Hi!
gt;
gt; Hit function key F5
gt; Click the Special button
gt; Select blanks
gt; OK
gt;
gt; This will select all empty cells in the USED RANGE.
gt;
gt; Enter a 0 in the formula bar then press CTRL ENTER.
gt;
gt; Biff
gt;
gt; quot;Userquot; gt; wrote in message ...
gt;gt; Hi,
gt;gt;
gt;gt; I've got an Excel file where some cells include zeros
gt;gt; and some are empty instead of including zero.
gt;gt; I need to have zeros in all empty cells.
gt;gt; How to do it for all cells in a sheet?
gt;gt;
gt;gt; I tried to use a quot;special copyquot; - without success.
gt;gt; I also tried to change them using Edit from the menu
gt;gt; but the empty cells are not found.
gt;gt;
gt;gt; I use Excel97. There are no formulas, just numbers in the sheet.
gt;gt;
gt;gt; Please help me. It's urgent. :-)
gt;gt;
gt;gt; Regards,
gt;gt; User
gt;gt;
gt;
gt;
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: www.excelforum.com/member.php...oamp;userid=33764
View this thread: www.excelforum.com/showthread...hreadid=535340You're welcome. Thanks for the feedback!

Biff

quot;Userquot; gt; wrote in message
...
gt; Thank you very much. It works!!!
gt;
gt; Regards,
gt; User
gt;
gt;
gt; U¿ytkownik quot;Biffquot; gt; napisa³ w wiadomo¶ci
gt; ...
gt;gt; Hi!
gt;gt;
gt;gt; Hit function key F5
gt;gt; Click the Special button
gt;gt; Select blanks
gt;gt; OK
gt;gt;
gt;gt; This will select all empty cells in the USED RANGE.
gt;gt;
gt;gt; Enter a 0 in the formula bar then press CTRL ENTER.
gt;gt;
gt;gt; Biff
gt;gt;
gt;gt; quot;Userquot; gt; wrote in message
gt;gt; ...
gt;gt;gt; Hi,
gt;gt;gt;
gt;gt;gt; I've got an Excel file where some cells include zeros
gt;gt;gt; and some are empty instead of including zero.
gt;gt;gt; I need to have zeros in all empty cells.
gt;gt;gt; How to do it for all cells in a sheet?
gt;gt;gt;
gt;gt;gt; I tried to use a quot;special copyquot; - without success.
gt;gt;gt; I also tried to change them using Edit from the menu
gt;gt;gt; but the empty cells are not found.
gt;gt;gt;
gt;gt;gt; I use Excel97. There are no formulas, just numbers in the sheet.
gt;gt;gt;
gt;gt;gt; Please help me. It's urgent. :-)
gt;gt;gt;
gt;gt;gt; Regards,
gt;gt;gt; User
gt;gt;gt;
gt;gt;
gt;gt;
gt;
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
Usergt; Hi,
gt;
gt; Try this out.
gt;
gt; suppose a2 is blank. write a given below formula is cel b2
gt;
gt; =IF(ISBLANK(A2)=TRUE,0,A2)
gt;
gt; Drag this formula till the cell you require. If the result is upto your
gt; satisfaction, then copy the range and paste as value i.e. paste special.
gt;
gt;
gt; Regards.
gt; Tejas Shah
gt;
gt;
gt; --
gt; TEJAS SHAH
gt; ------------------------------------------------------------------------
gt; TEJAS SHAH's Profile: www.excelforum.com/member.php...oamp;userid=33764
gt; View this thread: www.excelforum.com/showthread...hreadid=535340
gt;