Even though I have set the negative numbers format in Regional and Language
Settings to be "(1.1)". In Excel (no matter which version), whenever I
created a new worksheet, entering negative numbers always default to "-1.1".
How do a globally change Excel default to always use "(1.1)" for negative
number format, without me to keep on doing the formatting command?

Make your changes under the Currency Tab of Regional and Language Settings, not
under the Numbers Tab.


Gord Dibben MS Excel MVP

On Thu, 1 Jun 2006 17:04:33 +0800, "Hii Sing Chung" <(E-Mail Removed)> wrote:

>Even though I have set the negative numbers format in Regional and Language
>Settings to be "(1.1)". In Excel (no matter which version), whenever I
>created a new worksheet, entering negative numbers always default to "-1.1".
>How do a globally change Excel default to always use "(1.1)" for negative
>number format, without me to keep on doing the formatting command?
>

Actually I changed both the Numbers and Current Tab's negative number display to (1.1). In Excel, if I key in -$1.1 it will appear as ($1.1) but if just key in -1.1 it still appears as -1.1 and not (1.1) . Is it a bug? What I want is number, not currency.
"Gord Dibben" <gorddibbATshawDOTca> wrote in message news:(E-Mail Removed)...
Make your changes under the Currency Tab of Regional and Language Settings, not
under the Numbers Tab.


Gord Dibben MS Excel MVP

On Thu, 1 Jun 2006 17:04:33 +0800, "Hii Sing Chung" <(E-Mail Removed)> wrote:

>Even though I have set the negative numbers format in Regional and Language
>Settings to be "(1.1)". In Excel (no matter which version), whenever I
>created a new worksheet, entering negative numbers always default to "-1.1".
>How do a globally change Excel default to always use "(1.1)" for negative
>number format, without me to keep on doing the formatting command?
>

You must still set the format for those cells to (1.1)

Excel will not default to (1.1) when you type -1.1

I misinterpreted your original post. I assumed the (1.1) format was not
available.


Gord

On Sat, 3 Jun 2006 09:59:51 +0800, "Hii Sing Chung" <(E-Mail Removed)> wrote:

>Actually I changed both the Numbers and Current Tab's negative number display to (1.1). In Excel, if I key in -$1.1 it will appear as ($1.1) but if just key in -1.1 it still appears as -1.1 and not (1.1) . Is it a bug? What I want is number, not currency.
> "Gord Dibben" <gorddibbATshawDOTca> wrote in message news:(E-Mail Removed)...
> Make your changes under the Currency Tab of Regional and Language Settings, not
> under the Numbers Tab.
>
>
> Gord Dibben MS Excel MVP
>
> On Thu, 1 Jun 2006 17:04:33 +0800, "Hii Sing Chung" <(E-Mail Removed)> wrote:
>
> >Even though I have set the negative numbers format in Regional and Language
> >Settings to be "(1.1)". In Excel (no matter which version), whenever I
> >created a new worksheet, entering negative numbers always default to "-1.1".
> >How do a globally change Excel default to always use "(1.1)" for negative
> >number format, without me to keep on doing the formatting command?
> >