Formatting cells to Accounting

[Mel]

Hi

I previously was able to change the cell format to
Accounting and negative numbers were shown in brackets
and since installing the same office program onto WIn XP
where it previously was on Win98, this has dissapeared.
Now it only formats the negative numbers as $-5.00. I
need them for school to be in ($5.00) format. Is there
some option that I have missed in reloading to the XP
system? THere are other missing formats as well but this
is the more important one this semester, next it might be
the statistical formats. Thanks for the help!!
Mel

 

[Austin M. Horst]

Select the cell(s)
Click the Format menu
Click Cells...
Under Category, select Currency
Under Negative numbers, select the format


Austin M. Horst

 

[Bob Phillips]

If accounting is really missing, you can always create your own format
Format>Cells>Custom

$#,##0.00;($#,##0.00)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Dave Peterson]

There's a windows setting you can change:

The way I'd get to in Win98 is:

Windows Start button|settings|control panel|Regional Settings
Currency Tab|Negative Number Format

 

[Gord Dibben]

In Win XP it would be Start>Settings>Control Panel>Regional and Language
Options>Regional Options. Select your language from the drop-down then hit
"Customize" and "Currency" tab.

Gord Dibben Excel MVP

 

[Mel]

Thank you all so much!!!!
Mel

-----Original Message-----
In Win XP it would be Start>Settings>Control Panel>Regional and Language
Options>Regional Options. Select your language from the drop-down then hit
"Customize" and "Currency" tab.

Gord Dibben Excel MVP