I'm looking to format any negative numbers in a cell to be enclosed by parens instead of a minus sign - also, is there is list of format options?

 Since I couldn't figure out a format string, I thought I'd edit it in code, but that doesn't work for a read only cell.

 I assume there's no way to somehow assign code to the format property? (I did notice that a % sign in the format property will multiply the number by 100.)

Thanks,

Bill