Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]() 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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to make negative numbers to become 0? | Excel Worksheet Functions | |||
how do i make negative numbers equal zero | Excel Worksheet Functions | |||
Reformat telephone numbers in a column so all are formatted the s. | Excel Discussion (Misc queries) | |||
How to make negative numbers look like 0 | Excel Discussion (Misc queries) | |||
How do I make all numbers in a column negative in excel 2000? | Excel Discussion (Misc queries) |