converting negative amounts into positive amount

  • Experts,

    I have come accross a column that contains all paid orders but the amounts have a negative sign in front, how can I convert that netgative amount into a positve?

    please help

  • Multiply by -1.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • Well - assuming you REALLY want to do this (I mean - they were entered in as negative values for a reason, weren't they?), look into the Books online for the ABS function. should do what you ask.

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

  • THANK YOU!!!!!!:)

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply