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.

"Bernard Liengme" wrote:

In what respect? Give example
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

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