View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
James Hamilton
 
Posts: n/a
Default Custom Number Formats - Help

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!