| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I display negative numbers with parenthases in Excel?
On Monday, January 28, 2008 5:14:00 AM UTC+11, Nicole wrote:
Thank-you so much!! "Gord Dibben" wrote: If negative brackets are not available in the NumberNegative Numbers dialog. This is a function of your Regional Settings in Windows OS. StartSettingsControl PanelRegional and Language SettingsRegional OptionsCustomizeCurrencyNegative Currency Format. Click on drop-down arrow and select the ($1.1) Note: this is under the "Currency" tab in Regional Options. Changing under the "Numbers" tab only does not do the trick. Apply and OKApply your way out. Gord Dibben Excel MVP On Sun, 27 Jan 2008 09:02:05 -0800, Nicole wrote: Everytime I go to Format -- Cells -- Number or Currency, I can never get the ( ) option to show up for negative numbers! HELP!!!!!! Perfect !!! Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hide Negative Numbers or Display as Zero | Excel Worksheet Functions | |||
| How can I display negative numbers as zeros? | Excel Discussion (Misc queries) | |||
| how to display mainframe negative numbers on excel | Excel Worksheet Functions | |||
| display negative numbers as zero | Excel Discussion (Misc queries) | |||
| How do you display negative numbers in the unit price column? | Excel Worksheet Functions | |||
Threaded Mode
