My pleasure James.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"James Hamilton" wrote in message
...
Excellent - thanks Bob

"Bob Phillips" wrote:

_-* #,##0.00_-;[Red](#,##0.00);_-* "-"??_-

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"James Hamilton" wrote in message
...
I need to make a custom format so that my numbers have the following
attributes:

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

Thanks!