Custom Number Formats - Help

Giganews Newsgroups
Subject: Custom Number Formats - Help
Posted by:  James Hamilton
Date: Mon, 15 May 2006

I need to make a custom format so that my numbers have the following

- no dollar sign
- thousands shows with a comma; eg: 1,000
- negative numbers shows in red and in brackets with no negative sign; eg:
- zero amounts to be displayed as a " - " not as a blank cell.
- all numbers to be aligned to the right