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
OK, this worked - #,##0.00;(#,##0.00);-
Now I've just gotta find a reference to this syntax, in general. (Maybe in an Excel or VB reference guide...)
NumberFormatInfo class, then set the NumberFormatInfo to the column's
FormatInfo property.
The Format property on the grid column just applies the format by calling the ToString method of the cell's Value and passing in the format. So the formats are documented by Microsoft for each data type.