Thread: turning a negative into a positive
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ken Johnson Ken Johnson is offline
external usenet poster
  
Posts: 1,073
Default turning a negative into a positive
Hi childofthe1980s
In any spare cell type -1 then copy that cell, then select the column
of negative numbers, then go Edit, Paste Special and select the
Multiply operation, then click OK.
Ken Johnson

Reply With QuoteReply With Quote