LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 17
Default How do I make a column formatted for only Negative Numbers?


I'm trying to add-subtract various numbers. One column will be nothing but
withdrawals from an account, so I want every number to be negative, so that
if I do calculations with that column, they will always show as deductions.
Is there a way I can set up the cells in that column so that any number I
type in will show as a negative number, ie. a -xx? I can simply type in a
hyphen before, I know, but I like to type fast without even thinking about
that extra and somewhat difficult (for me) key-stroke. Thanks.

dc
 
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 make negative numbers to become 0? [email protected] Excel Worksheet Functions 1 October 26th 06 02:03 PM
how do i make negative numbers equal zero benny1 Excel Worksheet Functions 2 October 23rd 06 08:46 PM
Reformat telephone numbers in a column so all are formatted the s. Maree Excel Discussion (Misc queries) 2 March 1st 06 06:23 PM
How to make negative numbers look like 0 Trisha V via OfficeKB.com Excel Discussion (Misc queries) 12 August 5th 05 07:12 PM
How do I make all numbers in a column negative in excel 2000? jwoodruff77 Excel Discussion (Misc queries) 5 August 3rd 05 12:31 PM


All times are GMT +1. The time now is 09:59 AM.

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

About Us

"It's about Microsoft Excel"