Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
615
Grid summaries and DisplayFormat
posted

What is the right conditional DisplayFormat to show positive, negative, and zero values in a summary? I've tried things like this:

This works fine for positive values:  {0:#,##0.00}

but this doesn't work: {0:#,##0.00;(#,##0.00)}

nor this: {0:#,##0.00;(#,##0.00);#,##0.00}

According to MS they should work (http://msdn.microsoft.com/en-us/library/0c899ak8.aspx#SectionSeparator)  So wath's wrong?