Accounting format now no longer display negative figures in ( )'s

G

Guest

When selecting Accounting as the number format, negative figures used to
appear in brackets. That is now no longer the case. Negative figures using
the Accounting format now appear with a minus in front. I have never used
any version of Excel other than Office XP.
 
P

Peo Sjoblom

Use custom format and

_($* #,##0.00_);_($* (#,##0.00);_($* "-"??_);_(@_)

--
Regards,

Peo Sjoblom

(No private emails please)
 
D

Dave Peterson

Maybe....

Windows start button|settings|control panel|regional settings
(Or regional and language settings in winXP)

Regional Options tab, customize button in winxp

Currency Tab
change the negative currency format to show ()'s.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

show negative figures in brackets 3
Negative Number Display -- need Brackets 7
How do I get brackets in format cells accounting? 2
Negative figures in brackets 13
Formating Negative Figures in Brackets 2
Negative numbers use braces 4
Negative Number Formatting Excel 2007 1
Option to put brackets around negative numbers not available in 20 3

Top