| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I change the display of negative values to parentheses?
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 Mon, 10 Dec 2007 03:25:00 -0800, Dickson Nshindano wrote: |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I change all negative values in a column to = 0? | Excel Worksheet Functions | |||
| How do I change a range of values from + to -? | Excel Discussion (Misc queries) | |||
| How to display the negative bar in bar chart? | Charts and Charting in Excel | |||
| Negative or zero values cannot be plotted correctly on log charts | Charts and Charting in Excel | |||
| I Need a formula to evaluate a cell with + or - values | Excel Worksheet Functions | |||
Threaded Mode
