View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Umlas Bob Umlas is offline
external usenet poster
 
Posts: 301
Default can I remove negative symbols without a formula

Negative numbers DISPLAYED as positive numbers are still negative numbers!
Apply a format such as General;General
So if you SEE
3
3 and add them, if the first is "really" -3, the sum will still be 0.

"PMLACC" wrote in message
...
I have negative #'s that I want to make positive with a format rather than

a
formula. Is there any way to do this?