Thread: can I remove negative symbols without a formula
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default can I remove negative symbols without a formula
Not by formatting but.............

Enter -1 in a cell.

Copy it.

Select your range of negative numbers and Paste SpecialMultipleyOKEsc


Gord Dibben MS Excel MVP


On Fri, 25 Aug 2006 09:45:02 -0700, PMLACC
wrote:

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

Reply With QuoteReply With Quote