View Single Post
  #10   Report Post  
Gord Dibben
 
Posts: n/a
Default

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