Excel query

System
System Posts: 100,537 🤖 Admin 🤖
edited June 8 in Student general

I can export from my accounts package, lists of cheques.

But because it has them as 'credits', they appear in Excel as -000,000.00.

Is there any way I can format the cells so they appear as 000,000.00?


:cry:

Comments

  • System
    System Posts: 100,537 🤖 Admin 🤖
    Re:Excel query

    A few choices... assuming you don't want to write a macro

    1. Use a formula eg =if(a1<0,A1*-1,A1) poutting the converted cells into an empty area of the workshhet then copying them to overwrite the originals. Easy but inelegant.

    2. Download ASAP Excel utilities which has a utility to convert negatives to positives. Free and easy to install http://www.asap-utilities.com/index.php
  • System
    System Posts: 100,537 🤖 Admin 🤖
    Re:Excel query


    Chris - that is the most useful thing I have ever found on this forum!

    I've downloaded it and it is wonderful!

    Thanks for the tip!

    Helen
  • System
    System Posts: 100,537 🤖 Admin 🤖
    Re:Excel query
    1. Use a formula eg =if(a1<0,A1*-1,A1) poutting the converted cells into an empty area of the workshhet then copying them to overwrite the originals. Easy but inelegant.

    I use the Absolute function for this kind of thing. Syntax is =ABS(a1) if cell a1 contains a number, it is converted to its absolute value (ie without positive or negative signs). Which, to be fair, is only marginally less clumsy and you still have to copy and paste to overwrite the orginals.

Categories

Privacy Policy