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

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?

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

I had only set the numbers to brackets. I had not even noticed the currency
tab. Have now set the currency tab to brackets and Excel is now working
exactly how I want. Many thanks to all who have responded to my question.

"Gordon" wrote:

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

Valtam

Glad you're sorted out.

It is not intuitive to go to the Currency Tab when you are thinking "numbers".

Has confused many and I assume will continue to do so until/unless the two are
tied together.


Gord

On Sun, 27 Feb 2005 15:25:02 -0800, Valtam
wrote:

I had only set the numbers to brackets. I had not even noticed the currency
tab. Have now set the currency tab to brackets and Excel is now working
exactly how I want. Many thanks to all who have responded to my question.

"Gordon" wrote:

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