Thread: column of negative numbers into positive numbers
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default column of negative numbers into positive numbers
=-A1

"ORLFREIGHTBOY" wrote:

Hello all-

If I have a column of negative numbers and I want them all to become
positive numbers (-500 becomes 500, etc.), is there a quick way to do this?
Also, if the column has a positive number in it, I would that to become
negative...
Thanks - Jason
Reply With QuoteReply With Quote