LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to use subtract in excel 2003 mustafa Excel Worksheet Functions 1 March 8th 08 12:09 PM
subtract sum in one column from another bobby02169 Excel Discussion (Misc queries) 4 October 23rd 07 03:25 PM
How do I subtract one column from another? jewels New Users to Excel 4 October 1st 07 10:02 PM
HOW DO YOU ADD & SUBTRACT IN ONE COLUMN Stephanie Excel Worksheet Functions 1 September 25th 05 11:38 PM
How do I subtract 20% from one column in Excel and place totals i. Full Effect Landscaping Excel Discussion (Misc queries) 2 February 2nd 05 01:42 AM


All times are GMT +1. The time now is 08:04 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"