Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Negative numbers in parenthesis if not shown in drop down box
How do I get negative numbers in brackets if <Format<Cells<Numbers drop down
box does not show negative numbers in parenthesis. My spreadsheet shows negative numbers with a '-' minus sign. Thank you Sheron |
#2
|
|||
|
|||
Try custom formatting
#,##0;"("#,##0")" to display a negative value as (20) or #,##0;-"("#,##0")" to display -(20) Regards, "Pandorad" wrote in message ... How do I get negative numbers in brackets if <Format<Cells<Numbers drop down box does not show negative numbers in parenthesis. My spreadsheet shows negative numbers with a '-' minus sign. Thank you Sheron |
#3
|
|||
|
|||
Sheron
If bracketed negatives are not available in FormatCellsNumber..... 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) Apply and OKApply your way out. You will have to close Excel then re-open to see effects. You will then be able to choose that format. Gord Dibben Excel MVP On Sat, 30 Apr 2005 06:08:02 -0700, "Pandorad" wrote: How do I get negative numbers in brackets if <Format<Cells<Numbers drop down box does not show negative numbers in parenthesis. My spreadsheet shows negative numbers with a '-' minus sign. Thank you Sheron |
#4
|
|||
|
|||
Hi Gord Dibben & Alan,
Thanks for your earlier response. I changed the settings in control panel. Initially it had the '-' and it now shows (), however, my drop down box in numbers format still doesn't have the () and will not allow me to format negatives in parenthesis. Can you figure out what else I might need to do? Thanks so much for your help regards -- Pandorad "Pandorad" wrote: How do I get negative numbers in brackets if <Format<Cells<Numbers drop down box does not show negative numbers in parenthesis. My spreadsheet shows negative numbers with a '-' minus sign. Thank you Sheron |
#5
|
|||
|
|||
You changed the settings under the "Currency" tab in Regional Options?
Gord On Fri, 6 May 2005 19:11:06 -0700, "Pandorad" wrote: Hi Gord Dibben & Alan, Thanks for your earlier response. I changed the settings in control panel. Initially it had the '-' and it now shows (), however, my drop down box in numbers format still doesn't have the () and will not allow me to format negatives in parenthesis. Can you figure out what else I might need to do? Thanks so much for your help regards |
#6
|
|||
|
|||
The program is at the office so I will check on Monday. Hope that works.
Thanks again -- Pandorad "Gord Dibben" wrote: You changed the settings under the "Currency" tab in Regional Options? Gord On Fri, 6 May 2005 19:11:06 -0700, "Pandorad" wrote: Hi Gord Dibben & Alan, Thanks for your earlier response. I changed the settings in control panel. Initially it had the '-' and it now shows (), however, my drop down box in numbers format still doesn't have the () and will not allow me to format negatives in parenthesis. Can you figure out what else I might need to do? Thanks so much for your help regards |
#7
|
|||
|
|||
Hi Gord,
Thank you so much for your help. I changed the setting under 'currency' and it worked. I'm so relieved. My spreadsheets look more professional now Warm regards -- Pandorad "Pandorad" wrote: The program is at the office so I will check on Monday. Hope that works. Thanks again -- Pandorad "Gord Dibben" wrote: You changed the settings under the "Currency" tab in Regional Options? Gord On Fri, 6 May 2005 19:11:06 -0700, "Pandorad" wrote: Hi Gord Dibben & Alan, Thanks for your earlier response. I changed the settings in control panel. Initially it had the '-' and it now shows (), however, my drop down box in numbers format still doesn't have the () and will not allow me to format negatives in parenthesis. Can you figure out what else I might need to do? Thanks so much for your help regards |
#8
|
|||
|
|||
Great news.
Thanks for the feedback. Gord On Mon, 9 May 2005 19:11:02 -0700, "Pandorad" wrote: Hi Gord, Thank you so much for your help. I changed the setting under 'currency' and it worked. I'm so relieved. My spreadsheets look more professional now Warm regards |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I rank negative and positive numbers? | Excel Worksheet Functions | |||
How can I change positive numbers to negative, i.e. change 50 to - | Excel Discussion (Misc queries) | |||
How do I show negative numbers on a stacked graph | Charts and Charting in Excel | |||
Negative Numbers in Brackets - HELP! | Excel Discussion (Misc queries) | |||
can the negative numbers in an IF statement be in a diff color th. | Excel Worksheet Functions |