>Alex,
>Yeah not only Iformatprovider but .Net help is as clear as mud:)
>Try:
>

> dr[1]	= double.Parse(sValue, NumberStyles.Currency);
>

>PS: Add System.Globalization to using directives.
>Cetin

That certainly pointed me in the right direction. Changing the column format to string

dt.Columns.Add(new DataColumn("Value", typeof(String)));

and then later on

dr[1] = double.Parse(sValue, NumberStyles.Currency).ToString("C");

did it. They now show as currency in the grid even though it is entered as double. Go figure. But at least I can show the user now.

Thanks!