View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tyro[_2_] Tyro[_2_] is offline
external usenet poster
 
Posts: 1,091
Default 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