Thread: Converting Negative Numbers to Positive
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Francois via OfficeKB.com Francois via OfficeKB.com is offline
external usenet poster
  
Posts: 109
Default Converting Negative Numbers to Positive
bmmclen wrote:
There has to be a way to do this other than multiplying by -1???

Cell A1 enter a negative No.


in another cell enter =ABS(A1)


Answer is positive No.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200702/1

Reply With QuoteReply With Quote