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

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.

Use custom format and

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

--
Regards,

Peo Sjoblom

(No private emails please)


"R. Earl R." <R. Earl [email protected]> wrote in message
news:[email protected]...
> 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.

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.

R. Earl R. wrote:
>
> 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.

--

Dave Peterson