+ Reply to Thread
Results 1 to 3 of 3

Changing Positive to Negative

  1. #1
    Matthew Hackett via OfficeKB.com
    Guest

    Changing Positive to Negative

    This may be a really dumb question, but hey here goes.

    I have a column of positive monetary amounts (i.e. debits). They SHOULD be
    negative amounts (i.e. credits).

    Is there a way to change all of them from positives to negatives in one go?

    Thanks

  2. #2
    Guest

    Re: Changing Positive to Negative

    Hi
    Type -1 in a blank unused cell. Copy this, select your range and then
    Edit|Paste Special|Multiply.
    Take a copy of your sheet before you start!

    --
    Andy.


    "Matthew Hackett via OfficeKB.com" <forum@OfficeKB.com> wrote in message
    news:508482DF8AC10@OfficeKB.com...
    > This may be a really dumb question, but hey here goes.
    >
    > I have a column of positive monetary amounts (i.e. debits). They SHOULD be
    > negative amounts (i.e. credits).
    >
    > Is there a way to change all of them from positives to negatives in one
    > go?
    >
    > Thanks




  3. #3
    Matthew Hackett via OfficeKB.com
    Guest

    Re: Changing Positive to Negative

    Worked a treat - thank you

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1