lesser-equity

Magazine
Go Back   Computer Juice > Computer Software > Office Suites & Applications

Register


Default 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 ...


Reply
 
Thread Tools
  #1  
Old 30th May 2009, 13:35
New Member Group
 
Posts: 4
Default 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  
Old 30th May 2009, 13:38
Donor Group
 
Skill Level: Intermediate
Posts: 2,010
Default 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

Processor(s):
Quad Q6600 Kentsfield 2.66@3.45GHz
Motherboard:
Asus P5Q/L PRO (Intel P43, ICH10)
RAM Memory:
PNY XLR8 4GB @ 1066MHz
Graphics Card(s):
PNY nVidia GeForce 9400 GT 512MB
Sound Card:
Hard Drive(s):
Seagate HDBarracuda 1x 1TB 1x 250GB
Optical Drive(s):
LG (HD)GGCH20L / LG GH22NP20AUAA50B
Case / PSU:
Antec Sonata III & Earthwatts 500W
Cooling:
Stock
Network / Internet:
Gigabit LAN, FireWire & WG111v2
Monitor(s):
2 x Acer P193WAd
Operating System(s):
XP PRO x86/XP PRO x64/Win7 RC1 x64
Reply

Donate

Register

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




Arabic Bulgarian Chinese (Simplified) Chinese (Traditional) Croatian Czech Danish Dutch English Finnish French German Greek Hebrew Hungarian Italian Japanese Korean Latvian Lithuanian Norwegian Polish Portuguese Romanian Russian Serbian Slovak Spanish Swedish Thai Turkish Ukrainian

Copyright ©2006 - 2009 Computer Juice.

Powered by vBulletin® Copyright ©2000 - 2009 Jelsoft Enterprises Ltd. SEO by vBSEO ©2009, Crawlability, Inc.