How do I convert a column to negative numbers?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am looking for a quick way to covert a column of posative dollar amounts
into negative dollar amounts. Is there an easy way, other than retyping the
whole thing?

Thank you.
 
Vanilla,

Put -1 in a cell. Select it and Copy. Select the cells to be changes,
Edit - Paste Special - Multiply. Any currently negative amounts will become
positive.

Another approach is to change the number formatting (Format - Cells -
Number - Custom so that the numbers look negative, though they really
aren't.

-General
-0.00, etc.

Then in any formulas that use the numbers, subtract instead of add them.
 
Enter
-1
into a cell, then right click in it, and choose "Copy".

Select the cells you wish to revise,
Right click in this selection and choose "PasteSpecial".
Then click on "Multiply", then <OK>.

Would advise that you pre-format the cell containing the minus one (-1) to
the present format of the column you're changing, in order to retain the
present display.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


I am looking for a quick way to covert a column of posative dollar amounts
into negative dollar amounts. Is there an easy way, other than retyping the
whole thing?

Thank you.
 
Back
Top