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:21d2713946f38c9902e75e1db47@msnews.microsoft.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