Remove Negative Signs from Formula Results
You're welcome!
--
Biff
Microsoft Excel MVP
"Holly" wrote in message
...
Thankyou
--
Cheers,
Holly
"T. Valko" wrote:
Put your formula inside the ABS function:
=ABS(your_formula)
--
Biff
Microsoft Excel MVP
"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
|