software

I have a worksheet that uses a formula that subtracts tha amount from one
column from another. If nothing is entered in the first column a zero is
calculated and shows up in the second column. I save my sheet as csv file and
run it thru a cnc machine map reader and it does not like the zeros, I have
to manually go into the csv file and delete the zeros for it to work. how can
write or format the formula so if the resul is zero not to enter anything
into that cell

Formatgt;Cellsgt;Custom
In the Type box, delete everything between the 2nd and the 3rd semicolon

--
Kind regards,

Niek Otten

quot;lucho21quot; gt; wrote in message ...
gt;I have a worksheet that uses a formula that subtracts tha amount from one
gt; column from another. If nothing is entered in the first column a zero is
gt; calculated and shows up in the second column. I save my sheet as csv file and
gt; run it thru a cnc machine map reader and it does not like the zeros, I have
gt; to manually go into the csv file and delete the zeros for it to work. how can
gt; write or format the formula so if the resul is zero not to enter anything
gt; into that cell
Maybe something like this would help, let's say the cell you are calculating
is A1, where you have your formula enter =IF(A1=quot;quot;,quot;quot;,YOUR FORMULA HERE)

hope this helpsquot;lucho21quot; gt; wrote in message
...
gt; I have a worksheet that uses a formula that subtracts tha amount from one
gt; column from another. If nothing is entered in the first column a zero is
gt; calculated and shows up in the second column. I save my sheet as csv file
and
gt; run it thru a cnc machine map reader and it does not like the zeros, I
have
gt; to manually go into the csv file and delete the zeros for it to work. how
can
gt; write or format the formula so if the resul is zero not to enter anything
gt; into that cell
Both you and Nieks solutions will work, but I think the root of the problem
is that the formula stays in the cell, and this is what is causing the
problem. Is there a way to have a formula move down to the next cell
automatically?

quot;PH NEWSquot; wrote:

gt; Maybe something like this would help, let's say the cell you are calculating
gt; is A1, where you have your formula enter =IF(A1=quot;quot;,quot;quot;,YOUR FORMULA HERE)
gt;
gt; hope this helps
gt;
gt;
gt; quot;lucho21quot; gt; wrote in message
gt; ...
gt; gt; I have a worksheet that uses a formula that subtracts tha amount from one
gt; gt; column from another. If nothing is entered in the first column a zero is
gt; gt; calculated and shows up in the second column. I save my sheet as csv file
gt; and
gt; gt; run it thru a cnc machine map reader and it does not like the zeros, I
gt; have
gt; gt; to manually go into the csv file and delete the zeros for it to work. how
gt; can
gt; gt; write or format the formula so if the resul is zero not to enter anything
gt; gt; into that cell
gt;
gt;
gt;

That's a bit over my head. Could you not just Copygt;PasteSpecialgt;ValuesOnly.
Then you wouldn't have any formulas, only the results?
quot;lucho21quot; gt; wrote in message
...
gt; Both you and Nieks solutions will work, but I think the root of the
problem
gt; is that the formula stays in the cell, and this is what is causing the
gt; problem. Is there a way to have a formula move down to the next cell
gt; automatically?
gt;
gt; quot;PH NEWSquot; wrote:
gt;
gt; gt; Maybe something like this would help, let's say the cell you are
calculating
gt; gt; is A1, where you have your formula enter =IF(A1=quot;quot;,quot;quot;,YOUR FORMULA HERE)
gt; gt;
gt; gt; hope this helps
gt; gt;
gt; gt;
gt; gt; quot;lucho21quot; gt; wrote in message
gt; gt; ...
gt; gt; gt; I have a worksheet that uses a formula that subtracts tha amount from
one
gt; gt; gt; column from another. If nothing is entered in the first column a zero
is
gt; gt; gt; calculated and shows up in the second column. I save my sheet as csv
file
gt; gt; and
gt; gt; gt; run it thru a cnc machine map reader and it does not like the zeros, I
gt; gt; have
gt; gt; gt; to manually go into the csv file and delete the zeros for it to work.
how
gt; gt; can
gt; gt; gt; write or format the formula so if the resul is zero not to enter
anything
gt; gt; gt; into that cell
gt; gt;
gt; gt;
gt; gt;