Hi !
I would like that when I insert in a cell a value like "100,000,000" to be interpred by the grid as the number 100000000(one hundred millions) and when I insert a value like "201.33" the "." to be interpreted as "201 integer and 33 decimals" - by default if i use the "." character it just converts to "20133"
Any ideas ?
Thanks!
It sounds like the culture under which you are running uses the decimal (ASCII 46) as the thousands separator, and not the decimal separator.If this is the case you really shouldn't mess around with that because it will confuse users who are familiar with that culture.
Note that if I misunderstood this, and you are simply trying to change the format, you can do that with Format property. An example of a format for showing thousands separators is "###,###.00"
Hi Brian!
Well, it was a direct request from a customer, so it needs to be done.
I know that it might be a little weird, but i need that throughout the grid, when i insert a number , let's say "10000.55" (ten millions) to be formated automaticaly to "10,000.55". other examples :
100.5 => 100.5
10000.123 => 10,000.123
1.3 => 1.3
10000 => 10,000
Is there a way I can do this ?