Remove Negative Signs from Formula Results
Multiply by -1? Or use the unary operator to change the sign? If your
formula is =2-3 which produces -1, you can do something like =-(2-3) which
produces 1. It's just elementary algebra.
Tyro
"Holly" wrote in message
...
Hi All,
Does anyone know how to remove negative signs from formula results? This
is
more than just a formatting thing as the figures need to remain positive
when
a vlookup draws the data to another sheet and then when the data is
imported
into another program.
--
Cheers,
Holly
|