My regional setting in Windows XP Home shows negative number format to be in
brackets yet the number format in Excel 2003 still does not show the bracket
option?

Valtam wrote:
My regional setting in Windows XP Home shows negative number format
to be in brackets yet the number format in Excel 2003 still does not
show the bracket option?

Have you tried the Custom format?

--
Interim Systems and Management Accounting
Gordon Burgess-Parker
Director
www.gbpcomputing.co.uk

This is a windows setting.

Close excel

Change that windows regional setting|currency tab|Negative currency format
to show ($1.1)

Open excel

You may have to reformat:
Format|Cells|number tab|Number
(adjust the decimal places and comma options)

Valtam wrote:

My regional setting in Windows XP Home shows negative number format to be in
brackets yet the number format in Excel 2003 still does not show the bracket
option?

--

Dave Peterson

Valtam

Set Currency for brackets in Regional Settings. Number alone won't do the
trick.


Gord Dibben Excel MVP



On Sat, 26 Feb 2005 11:21:05 -0800, Valtam
wrote:

My regional setting in Windows XP Home shows negative number format to be in
brackets yet the number format in Excel 2003 still does not show the bracket
option?

Gord Dibben wrote:
Valtam

Set Currency for brackets in Regional Settings. Number alone won't
do the trick.


Gord Dibben Excel MVP

Umm the OP said he'd already done that........


--
Interim Systems and Management Accounting
Gordon Burgess-Parker
Director
www.gbpcomputing.co.uk

Maybe the OP looked at the Numbers tab, not the Currency tab (under the regional
settings applet).

Gordon wrote:

Gord Dibben wrote:
Valtam

Set Currency for brackets in Regional Settings. Number alone won't
do the trick.


Gord Dibben Excel MVP

Umm the OP said he'd already done that........

--
Interim Systems and Management Accounting
Gordon Burgess-Parker
Director
www.gbpcomputing.co.uk

--

Dave Peterson

Gordon

Ummm. Re-read the original. Quoted below.

My regional setting in Windows XP Home shows negative number format to be in
brackets yet the number format in Excel 2003 still does not show the bracket
option?

I see no mention of the Currency Setting in Regional Options.


Other Gord

On Sun, 27 Feb 2005 06:50:58 -0600, Dave Peterson
wrote:

Maybe the OP looked at the Numbers tab, not the Currency tab (under the regional
settings applet).

Gordon wrote:

Gord Dibben wrote:
Valtam

Set Currency for brackets in Regional Settings. Number alone won't
do the trick.


Gord Dibben Excel MVP

Umm the OP said he'd already done that........

--
Interim Systems and Management Accounting
Gordon Burgess-Parker
Director
www.gbpcomputing.co.uk

Gord Dibben wrote:
Gordon

Ummm. Re-read the original. Quoted below.

My regional setting in Windows XP Home shows negative number format
to be in brackets yet the number format in Excel 2003 still does not
show the bracket option?

I see no mention of the Currency Setting in Regional Options.


Other Gord

On Sun, 27 Feb 2005 06:50:58 -0600, Dave Peterson
wrote:

Maybe the OP looked at the Numbers tab, not the Currency tab (under
the regional settings applet).

Gordon wrote:

Gord Dibben wrote:
Valtam

Set Currency for brackets in Regional Settings. Number alone won't
do the trick.


Gord Dibben Excel MVP

Umm the OP said he'd already done that........

--
Interim Systems and Management Accounting
Gordon Burgess-Parker
Director
www.gbpcomputing.co.uk

So who introduced Currency? Not me!

--
Interim Systems and Management Accounting
Gordon Burgess-Parker
Director
www.gbpcomputing.co.uk