Formatting cell for Accounting Format

1 reply. Last post: July 13, 2011 9:22 AM by Beryl Bucher
Tags :
  • New Discussion
  • New Question
  • New Product Feedback
Beryl BucherMember

I'm formatting cells a read-only webgrid (one by one) in code-behind, and it's successful so far.  The only bits I'm missing is that I need accounting formats: 

negative numbers should be formatted like "(123)" instead of "-123", and 

zeros should be "-" rather than "0".

I've tried the dataformatstring = "$#,##0.00;($#,##0.00);-" but that doesn't seem to work.  Do you have any suggestions?

Many thanks!

Beryl

All times are GMT -5. The time now is 12:18 PM.
Previous Next