Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Excel 2000 brackets on negative numbers
0 views
Skip to first unread message
sandy
Feb 12, 2004, 4:25:24 PM2/12/04
to
On Feb 11/04 I put out a call for help with brackets on
negative numbers...Gord Dibben replied to say go out to
set regional settings...I have done this and brackets
still don't show up...I even rebooted the PC...any other
suggestions.
negative numbers...Gord Dibben replied to say go out to
set regional settings...I have done this and brackets
still don't show up...I even rebooted the PC...any other
suggestions.
Roger Whitehead
Feb 13, 2004, 3:21:02 AM2/13/04
to
Have you tried a Custom number format?
Format, Cells, Custom.
There is probably a suitable option in the list. Check OLH for formatting
instructions, but something like:
Format, Cells, Custom.
There is probably a suitable option in the list. Check OLH for formatting
instructions, but something like:
#,##0.00_);[Red](#,##0.00)
should do. Explanation
To the left of the semi-colon is the format for positive numbers
"_)" indicates that the number is padded at the right end to line up
with a bracket in another element of the format
To the right of teh semi-colon is teh format element for negative numbers:
[Red] instructs the font colour
Brackets either side indicates brackets required
#,##0.00 indicates zeroes to be displayed for Units & 2 decimals
Other numbers only as relevant
comma as thousands separator
--
HTH
Roger
Shaftesbury (UK)
"sandy" <anon...@discussions.microsoft.com> wrote in message
news:ef5e01c3f1ae$b9d47d20$a301...@phx.gbl...
0 new messages