C# – Formating numeric cells to "###,###.##"

[User (Old forums)]

#13484 |

How can I format the cells of an specific column to have the following format: “###,###.##” ?

Imported from legacy forums. Posted by EFileTahi-A (had 695 views)

[User (Old forums)]

#13485

Xceed.Grid.Column myColumn = myGrid.Columns[“myColumn”];
myColumn.DataProvider = System.Globalization.CultureInfo.CurrentCulture.NumberFormat;
myColumn.DataSpecifier = “###,###.##”;

Imported from legacy forums. Posted by Tommy (had 183 views)

[User (Old forums)]

#13486

Tks once more Tommy…

Unfortunately it works badly, I mean, with “###.###,##” mask I get not format at all, but, if I change the “,” and “.” it formats like this: “###.###.###”, I never have the 2 digit decimal yet, I do not even get the “,”…

Hope to hear from you soon

Imported from legacy forums. Posted by EFileTahi-A (had 407 views)

[User (Old forums)]

#13487

I mean if I sawnp the “,” and “.” I get ###.###.### format with no 2 decimal case and it just ignores the use of the “,”

Damn, is there away to edit the posts?

Imported from legacy forums. Posted by EFileTahi-A (had 380 views)

[User (Old forums)]

#13488

If you always want the decimals (even if the numbers don’t have decimals), use “###,##0.00”, which will always show the decimals.

Imported from legacy forums. Posted by Tommy (had 182 views)

[User (Old forums)]

#13489

Great! That works perfectly! 🙂 I hope you can post in my other thread too…

Imported from legacy forums. Posted by EFileTahi-A (had 4981 views)

[Author]

Posts