Thread: How do I convert existing excel numbers to negative?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default How do I convert existing excel numbers to negative?
Place a -1 in an un-used cell and copy that cell. Then select all the cells
you want to convert and:

Edit PasteSpecial Multiply
--
Gary''s Student - gsnu200762


"nadeaus6" wrote:

I have large amounts of excel data that i need to convert from positive to
negative. Is there a way to accomplish this?
Thanks.
Reply With QuoteReply With Quote