Thread: col of minus numbers changed to plus numbers
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
  
Posts: 5,939
Default col of minus numbers changed to plus numbers
Place a -1 in any unused cell. Copy that Cell. Highlight the cells you want
to flip the sign on. Now right click and select PasteSpecial - multiply...
--
HTH...

Jim Thomlinson


"Cecil1234" wrote:

have long column of numbers showing as minus that was imported to worksheet.
need to convert them to plus.
Reply With QuoteReply With Quote