How to format decimal figures limiting the # of decimals, place commas or not. Same for currency.
Posted on 2005-03-25
I am loading a datagrid with a decimal field and have chosen a "C" format in my column mapping. The source field is decimal, scale of 0. The display gives me $ sign, commas and two decimals. I went to a format "D" and the same result minus the $ sign. I think there should be a rather easy way to control the basic numeric display formatting but beyond using "C" or "D" I can't seem to find the answer. Also, will the answer work for a text box as well?