Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I display negative numbers with parenthases in Excel?
Everytime I go to Format -- Cells -- Number or Currency, I can never get
the ( ) option to show up for negative numbers! HELP!!!!!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I display negative numbers with parenthases in Excel?
Format Cells... Nymber Custom $#,##0.00_);($#,##0.00)
-- Gary''s Student - gsnu200766 "Nicole" wrote: Everytime I go to Format -- Cells -- Number or Currency, I can never get the ( ) option to show up for negative numbers! HELP!!!!!! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I display negative numbers with parenthases in Excel?
Select the cell with the number you want to format then: Format Cells -
Number (or Currency) - Negative numbers: Select one of the numbers in parentheses. Works fine in Excel 2007 Tyro "Nicole" wrote in message ... Everytime I go to Format -- Cells -- Number or Currency, I can never get the ( ) option to show up for negative numbers! HELP!!!!!! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I display negative numbers with parenthases in Excel?
You could change the format of the cell, but if you want the ()'s to show up for
negative numbers in the format|cells|number tab, you'll have to change a windows setting. Windows start button|control panel regional and language options regional options tab click the customize button currency tab change the negative currency format to show ()'s. Nicole wrote: Everytime I go to Format -- Cells -- Number or Currency, I can never get the ( ) option to show up for negative numbers! HELP!!!!!! -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I display negative numbers with parenthases in Excel?
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!!!!!! |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I display negative numbers with parenthases in Excel?
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!!!!!! |
#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 |
Reply |
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 |