ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I convert existing excel numbers to negative? (https://www.excelbanter.com/excel-discussion-misc-queries/170754-how-do-i-convert-existing-excel-numbers-negative.html)

nadeaus6

How do I convert existing excel numbers to negative?
 
I have large amounts of excel data that i need to convert from positive to
negative. Is there a way to accomplish this?
Thanks.

Gary''s Student

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.



All times are GMT +1. The time now is 02:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com