Any way to convert column of numbers from positive to negative?

  • Thread starter Thread starter Sue
  • Start date Start date
S

Sue

Hi all,

Is there any way to convert a column of numbers that are positive to be
negative? We create a text file from our general ledger program that has all
the transactions for the past year, then import that file into Excel. We use
the text to columns to convert the text file to a usable format where the debits
are in one column and the credits in another. The problem is that all the
numbers are shown as positive so when we net various figures the amount is not
correct. Here's an example:

DR-amount CR-amount
8,239.32
23,545.26
18,028.12
200,000.00
15,490.71
652.20
16,590.00
130.00
8.00
654.75
308.00
895.09

I want all the numbers in the credit column to be negative; is there any way to
do this without manually editing every entry? Thanks!

Sue
 
Hi Sue

yes, type a -1 in a cell somewhere and copy it, select your credit column
and choose edit / paste special / multiply

Cheers
JulieD
 
Hi
One way is to type -1 in a blank unused cell. Copy this and then select your
CR column. Click Edit / Paste Special / Multiply.
Make sure you back-up your sheet before you start.
 
No wonder I didn't think of that - it's too easy! 8*) Thanks very much to you
and Julie!

Sue
 
Back
Top