Hi Joe,

You can set the DataFormatString for the BoundColumn to:

{0:c}

Which will format the data as currency (thereby putting in the $, decimal place, and appropriate digits after the decimal place).


>I have a grid with a dynamic SQL that has a SQL data type 'money' that insists on the full display of 4 decimal places to the left. How can I format the col on the fly?
>
>My thanks in advance,