| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I format a negative number in parenthesis?
oops should have said remove the
[red] if you don't want it in red as well as parenthesis. -- Cheers JulieD julied_ng at hctsReMoVeThIs dot net dot au "JulieD" wrote: Hi John click on the cell choose format / cell under CUSTOM type #,##0.00;[Red](#,##0.00) this should give you what you want. -- Cheers JulieD julied_ng at hctsReMoVeThIs dot net dot au "John Nollett" wrote: The format cell does not alllow for parenthesis around negative numbers with decimal places? How can I set this up? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| number format | Excel Discussion (Misc queries) | |||
| number format | Excel Discussion (Misc queries) | |||
| Custom number format always defaults last number to 0. | Excel Discussion (Misc queries) | |||
| How do I replace a negative number at the end of a formula with a. | Excel Discussion (Misc queries) | |||
| How do i change numbers in text format to number format? | New Users to Excel | |||
Threaded Mode
