| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
I don't use Lotus, but I see your point.
Gordon wrote: Dave Peterson wrote: Close excel Change that windows regional setting|currency tab|Negative currency format to show ($1.1) Open excel If you click on Format|cells|Number tab then choose Number, do your formatting options include ()'s for negative numbers. They do for me. They do. That's NOT the point I was making. the point I was making, is that in Lotus, if Regional Settings are set to (1.1), then when you enter -1.1 in a cell, it is AUTOMATICALLY formatted to (1.1) - you don't have to DO anything! -- Interim Systems and Management Accounting Gordon Burgess-Parker Director www.gbpcomputing.co.uk -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get negative numbers to show as brackets? | Excel Discussion (Misc queries) | |||
| Converting negative numbers in a range of cells to zero | Excel Discussion (Misc queries) | |||
| can the negative numbers in an IF statement be in a diff color th. | Excel Worksheet Functions | |||
| Subtracting Negative Numbers | Excel Worksheet Functions | |||
| Negative Numbers | Excel Discussion (Misc queries) | |||
Hybrid Mode
