View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Holly Holly is offline
external usenet poster
 
Posts: 94
Default Remove Negative Signs from Formula Results

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