View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Marcelo Marcelo is offline
external usenet poster
 
Posts: 1,047
Default can I remove negative symbols without a formula

Hi,

bob is right, but if you need to change negative to positive,

copy the range and paste special values and subtracting

or use an auxiliar cell, type -1 copy it and paste special values and multiply

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"PMLACC" escreveu:

I have negative #'s that I want to make positive with a format rather than a
formula. Is there any way to do this?