View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default How to change positive numbers to negative numbers without re-ente

Which does exactly the opposite of what was asked.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"John Michl" wrote in message
oups.com...
You could also use the formula abs(A1) which is the absolute value of
A1 and will always be positive.

- John