I seem unable to display negative values with brackets
 

Under - format - cells - number - negative numbers I do not have the option
to choose 'brackets'

I seem unable to display negative values with brackets
 

Hi

Maybe you need to go to Control PanelRegional
SettingsCustomiseNegative number format.
On my machine I get the option for brackets even when this is set
to -1.1, but maybe for you, you need to set negative format to (1.1)

--
Regards

Roger Govier


"Ferd" wrote in message
...
Under - format - cells - number - negative numbers I do not have the
option
to choose 'brackets'

I seem unable to display negative values with brackets
 

Hi also.

When in Regional Settings, change the setting under "Currency" tab rather than
the "Number" tab.


Gord Dibben MS Excel MVP

On Tue, 31 Jan 2006 07:35:54 -0000, "Roger Govier"
wrote:

Hi

Maybe you need to go to Control PanelRegional
SettingsCustomiseNegative number format.
On my machine I get the option for brackets even when this is set
to -1.1, but maybe for you, you need to set negative format to (1.1)

I seem unable to display negative values with brackets
 

Hi Gord

I think you had pointed this out to me once before. Sorry, the brain is
getting"addled" today, and I totally forgot.
Thanks for the memory jog.

--
Regards

Roger Govier


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Hi also.

When in Regional Settings, change the setting under "Currency" tab
rather than
the "Number" tab.


Gord Dibben MS Excel MVP

On Tue, 31 Jan 2006 07:35:54 -0000, "Roger Govier"
wrote:

Hi

Maybe you need to go to Control PanelRegional
SettingsCustomiseNegative number format.
On my machine I get the option for brackets even when this is set
to -1.1, but maybe for you, you need to set negative format to (1.1)