I seem unable to display negative values with brackets

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

Hi

Maybe you need to go to Control Panel>Regional
Settings>Customise>Negative 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" <Ferd@discussions.microsoft.com> wrote in message
news:7A7E8B87-4CEB-4030-9C88-E4125BA09EFB@microsoft.com...
> Under - format - cells - number - negative numbers I do not have the
> option
> to choose '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"
<roger@technologyNOSPAM4u.co.uk> wrote:

>Hi
>
>Maybe you need to go to Control Panel>Regional
>Settings>Customise>Negative 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)

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
news:ktbvt190coenast7co4064c4sqk1qmcuh0@4ax.com...
> 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"
> <roger@technologyNOSPAM4u.co.uk> wrote:
>
>>Hi
>>
>>Maybe you need to go to Control Panel>Regional
>>Settings>Customise>Negative 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)
>