I am using formatting like this for currency and date

<asp:BoundField DataField="Cost" HeaderText="Cost" DataFormatString={0:C2} SortExpression="Cost" />
<asp:BoundField DataField="Dt" HeaderText="Dt" DataFormatString={0:d} SortExpression="Dt" />

Neither one works. What am I doing wrong? Please help!

You need to set HtmlEncode for the field to False.

When this attribute is True, then DataFormatString is not applied.

HtH,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Thanks a lot! It worked! :)