|
|
|||||||
|
 Making my own checkbook system
|
|
|
|
Im making my own checkbook system, and in the debit column i want the numbers to appear in red with parentheses around the numbers without having to put -100.00 in as an example. i want to enter the debits into the column and excel know it is a negative and ...
|
 |
|
|
Thread Tools |
|
#1
30th May 2009, 13:35
|
|||
|
|||
|
Making my own checkbook system
Im making my own checkbook system, and in the debit column i want the numbers to appear in red with parentheses around the numbers without having to put -100.00 in as an example. i want to enter the debits into the column and excel know it is a negative and therefore put it in the format i mentioned.
i dont not want to have to use the - sign for every debit. for the life of me i cannot figure this out, formatting cells with number dialog box doesnt work since it sees the numbers as positive, please help me. thanks in advance, :pray: excel 2007 btw |
|
#2
30th May 2009, 13:38
|
||||||||||||
|
||||||||||||
|
Making my own checkbook system
Right click
__________________
Format Numbers tab Select Currency, and then select the option for negative numbers in red and parenthesis. Click ok, and you should have it. My System: FordyPC
|
|
|
|
| Bookmarks |
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| All USB Devices without independent power supply hangs my system or make the system run very slow | lightfoot | General Hardware Chat | 10 | 18th Mar 2009 05:48 |
| Making web page | antbann | Web Design, Hosting & SEO | 6 | 5th Jan 2009 06:56 |
| Making Server | ashaiba | Networking, Modems & VoIP | 6 | 22nd Dec 2008 21:26 |
| System restore/ system recovery | ct122592 | Windows Operating Systems | 1 | 2nd Jan 2008 18:49 |
| Making My First PC. | Counterstriker | General Hardware Chat | 14 | 20th Dec 2007 03:01 |
| Thread Tools | |
|
|
