«

I have tried to set a gridview column to have a dataformatstring of {0:c2},
{0:c},{0:d2, {0:d}, none of which work, my values are still displaying as
19.0000. I want it to be 19.00 like any normal currency. Thank you for
your help.

Hello Kat,

Are you sure that your seetings for the currency use dot for delimiter?

Martin

> I have tried to set a gridview column to have a dataformatstring of
> {0:c2}, {0:c},{0:d2, {0:d}, none of which work, my values are still
> displaying as 19.0000. I want it to be 19.00 like any normal
> currency. Thank you for your help.
>

Not sure what you mean, when I use currency formats in other programs, such
as Excel, it works fine. What should I check?


"martin marinov" <> wrote in message
news:. com...
> Hello Kat,
>
> Are you sure that your seetings for the currency use dot for delimiter?
>
> Martin
>
>> I have tried to set a gridview column to have a dataformatstring of
>> {0:c2}, {0:c},{0:d2, {0:d}, none of which work, my values are still
>> displaying as 19.0000. I want it to be 19.00 like any normal
>> currency. Thank you for your help.
>>
>
>

Kat wrote:
> Not sure what you mean, when I use currency formats in other programs, such
> as Excel, it works fine. What should I check?

You did everything right. But there is a feature that is poorly
described in guides. If you want to use DataFormatString then you have
to set
HtmlEncode to false.

<asp:BoundField .... HtmlEncode="False" DataFormatString="${0:C2}"/>

Regards, Mykola
http://marss.co.ua