View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
[email protected] tal.simon.home@gmail.com is offline
external usenet poster
 
Posts: 1
Default 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