Thanks for your help. Problem is, a -1 is a legitmate value if the numeric
value is 0.000.

"RagDyeR" wrote:

If you're using a formula like:

=A1-1

Then try this:

=If(A1,A1-1,"")

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Bob Aloisi" wrote in message
...
I've imported data into Excel and two columns are defined as numeric, 3
decimal places. When using them in a compute, I subtract 1 from the value.
For those that are blank, the result from the compute is -1. I'd prefer the
result be blank as well.

"RagDyeR" wrote:

Depends on what and how you're using them.

Care to elaborate more, with examples?
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"Bob Aloisi" wrote in message
...
How can I stop Excel from treating blanks as zeroes in a numeric field?