Displaying negative numbers in parentheses

edgop
edgop used Ask the Experts™
on
Am using Access 2000 and want to have my negative numbers, both fixed and currency display in parenthesis rather than with the dash in front in my reports.  
Thanks for any help.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Place this in the format section:  0;(0);;"Null"    

Author

Commented:
That works great, thanks.  One other thing, how can I do when I want it to display a percent, is that possible too?
You can set the format to: percent
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

Commented:
What I mean is how can I have it be (17%) for -17%. Thanks.  They may be incompatible, just let me know, obviously I am clueless on this one.
Put this in the format section: 0%;(0%);;"Null"
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
- Answered by stretchsp
Please leave any comments here within the
next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !

nexus
per recommendation

SpideyMod
Community Support Moderator @Experts Exchange

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial