Thread: Change negative nmbr to positive
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Dave is offline
external usenet poster
  
Posts: 1,388
Default Change negative nmbr to positive
Hi Tom,
Select Replace from the Edit menu.
In the Find What field, put -
Leave the Replace With field blank.
Click Replace All (if there are no wanted negative numbers on the sheet)
Regards - Dave.
Reply With QuoteReply With Quote