EXCELlent Ones Consulting Skip to Content Skip to Search

Print  |   | Download PDF

Reverse Number Signs Quickly

In the financial and accounting world positive and negative numbers are used very often. These numbers denote many things such as profits, costs and accounting entries to name a few. It is a common to reverse the signs of a group of numbers very quickly. Below is a quick tip on how to do this in Excel.

1. Above is an accounting journal entry filled with debits and credits.

2. In a separate column type in the cell address then multiply by -1 (ex. =A2*-1)

3. Copy this formula to the subsequent rows

a. A reversing journal entry has been created

4. Copy the new data

5. Right click over the same area

6. Paste special as values

These last three steps will hardcode the values unto the spreadsheet.


Footer

Email: info@excellentones.com | P.O. Box 160493 | Brooklyn, NY 11216 | Phone: (347) 763-1035 | Fax: (718) 228-7859

All rights reserved. Copyright 2014 Excellent Ones Consulting LLC.