View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Meebers Meebers is offline
external usenet poster
 
Posts: 80
Default How to reverse sign?

multiply by -1. i.e. a1=-213, in bi =a1*-1 then copy/past special/values
and place results were you need them. ??

"Chips" wrote in message
...
Excel 2007

I have a column of numbers, all negative.
Like:
-213.00
-4,521.78


I want to change them to positive.

Not sure how to do this.

Thanks,

GC