| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format Cell Number Options missing
Format Cell Number Options
in the options for Negative numbers only has the format for colour black and no brackets, doesn't have format black with brackets has no options for format colour red and or red with bracket checked to see if it was document specific opened a new blank workbook, and same in a new workbook checked not using a start template |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format Cell Number Options missing
Look in Custom formats.
-- David Biddulph "Nadine" wrote in message ... Format Cell Number Options in the options for Negative numbers only has the format for colour black and no brackets, doesn't have format black with brackets has no options for format colour red and or red with bracket checked to see if it was document specific opened a new blank workbook, and same in a new workbook checked not using a start template |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format Cell Number Options missing
Not in custom formats
"David Biddulph" wrote: Look in Custom formats. -- David Biddulph "Nadine" wrote in message ... Format Cell Number Options in the options for Negative numbers only has the format for colour black and no brackets, doesn't have format black with brackets has no options for format colour red and or red with bracket checked to see if it was document specific opened a new blank workbook, and same in a new workbook checked not using a start template |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format Cell Number Options missing
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 Wed, 2 Apr 2008 11:46:03 -0700, Nadine wrote: Format Cell Number Options in the options for Negative numbers only has the format for colour black and no brackets, doesn't have format black with brackets has no options for format colour red and or red with bracket checked to see if it was document specific opened a new blank workbook, and same in a new workbook checked not using a start template |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format Cell Number Options missing
it brought back the brackets and the red formatting, but doesn't have the
minus in front of the numbers. "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 Wed, 2 Apr 2008 11:46:03 -0700, Nadine wrote: Format Cell Number Options in the options for Negative numbers only has the format for colour black and no brackets, doesn't have format black with brackets has no options for format colour red and or red with bracket checked to see if it was document specific opened a new blank workbook, and same in a new workbook checked not using a start template |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format Cell Number Options missing
Disre regard previous post. Was looking at it wrong.
Your fix worked. Thanks "Nadine" wrote: it brought back the brackets and the red formatting, but doesn't have the minus in front of the numbers. "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 Wed, 2 Apr 2008 11:46:03 -0700, Nadine wrote: Format Cell Number Options in the options for Negative numbers only has the format for colour black and no brackets, doesn't have format black with brackets has no options for format colour red and or red with bracket checked to see if it was document specific opened a new blank workbook, and same in a new workbook checked not using a start template |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format Cell Number Options missing
Thanks for the feedback.
Gord On Thu, 3 Apr 2008 10:19:00 -0700, Nadine wrote: Disre regard previous post. Was looking at it wrong. Your fix worked. Thanks "Nadine" wrote: it brought back the brackets and the red formatting, but doesn't have the minus in front of the numbers. "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 Wed, 2 Apr 2008 11:46:03 -0700, Nadine wrote: Format Cell Number Options in the options for Negative numbers only has the format for colour black and no brackets, doesn't have format black with brackets has no options for format colour red and or red with bracket checked to see if it was document specific opened a new blank workbook, and same in a new workbook checked not using a start template |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel negative number format options don't include brackets. Why? | Excel Discussion (Misc queries) | |||
| title bar missing options | Excel Discussion (Misc queries) | |||
| Format Cell to Overwrite Decimal Separator in Options | Excel Discussion (Misc queries) | |||
| Newbie - Need help with zipcode format- no options for cell | Excel Worksheet Functions | |||
| Missing Data Options | Charts and Charting in Excel | |||
Linear Mode
