Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Tell a column to always subtract --Excel 2003
Hi All! Is there a way to tell a column that if it sees a number it should
always be read as a negative? I am creating a checkbook registry and have deposits in the plus column and would like the checks to automatically be calculated as a negative amount. I can hit the minus sign every time, but would be helpful if it just knew to do it. ---I apologize if this is a duplicate question---I tried to post it last week and I'm unable to find it. That brings me to another question----more about the site, rather than just Excel---When searching for answers -- i.e. Subtract---is there a way to say I want my answers to show latest posts first? When I ran the query the answers came up in no particular order and I was looking specifically for my post and any answers to it. I thought I could do this in the past---but cannot remember how i did it. This is one of the BEST SITES anywhere for help...have been using it for years and I really appreciate any help you can give me. THANKS!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to use subtract in excel 2003 | Excel Worksheet Functions | |||
subtract sum in one column from another | Excel Discussion (Misc queries) | |||
How do I subtract one column from another? | New Users to Excel | |||
HOW DO YOU ADD & SUBTRACT IN ONE COLUMN | Excel Worksheet Functions | |||
How do I subtract 20% from one column in Excel and place totals i. | Excel Discussion (Misc queries) |