Convert Currency-formatted string back to decimal

[KB]

Hi guys,

In my DataGrid I have a column that displays decimal values as currency ( I
set the Data Formatting expression of that column to {0:C}). So the actual
string displayed in the grid looks like $2,295.99.
For each row I need to do some additional calculations based on this value,
so I need to convert it back to decimal type. But I cannot find a way to get
rid of the currency formatting and revert the value back to decimal. I tried
the following:

Convert.ToDecimal( e.Item.Cells[ColValue].Text ); // Input string was
not in a correct format
String.Format( "{0:N}", e.Item.Cells[ColValue].Text) // returns $2,295.99
String.Format( "{0:D}", e.Item.Cells[ColValue].Text) // returns $2,295.99
String.Format( "{0:G}", e.Item.Cells[ColValue].Text) // returns $2,295.99
String.Format( "{0:R}", e.Item.Cells[ColValue].Text) // returns $2,295.99

Anyone knows how to solve this.

Cheers

Kevin

[Mark Fitzpatrick]

Kevin,
Just remove the $ and the , like so
e.Item.Cells[ColValue].Text.Replace("$","").Replace(",",""). The replace
just replaces them with nothing, essentially removing them from the string.

Hope this helps,
Mark FItzpatrick
Microsoft MVP - FrontPage

"KB" <[e-mail]> wrote in message
news:eo******************@TK2MSFTNGP15.phx.gbl...

Hi guys,

In my DataGrid I have a column that displays decimal values as currency
( I
set the Data Formatting expression of that column to {0:C}). So the actual
string displayed in the grid looks like $2,295.99.
For each row I need to do some additional calculations based on this
value,
so I need to convert it back to decimal type. But I cannot find a way to
get
rid of the currency formatting and revert the value back to decimal. I
tried
the following:

Convert.ToDecimal( e.Item.Cells[ColValue].Text ); // Input string
was
not in a correct format
String.Format( "{0:N}", e.Item.Cells[ColValue].Text) // returns
$2,295.99
String.Format( "{0:D}", e.Item.Cells[ColValue].Text) // returns
$2,295.99
String.Format( "{0:G}", e.Item.Cells[ColValue].Text) // returns
$2,295.99
String.Format( "{0:R}", e.Item.Cells[ColValue].Text) // returns
$2,295.99

Anyone knows how to solve this.

Cheers

Kevin

[Alex Homer]

Have you tried this:
http://msdn.microsoft.com/library/de...parsetopic.asp

It sounds like it should work...