Custom Number Formats - Help

[James Hamilton]

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!

 

[Bob Phillips]

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

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

 

[James Hamilton]

Excellent - thanks Bob

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

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

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!

 

[Bob Phillips]

My pleasure James.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

Excellent - thanks Bob

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

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

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!