Currency in DataGrid


I’ve got a datagrid and would like to know if it is possible to have a column formatted with currency.

So, for example I have the values 20, 30, 40 in my “price” column. But I want them to say £20, £30, £40. Problem is I can do that easy,

"£ "+price

But, when calculating totals I need to do this:


The £ pound sign messes it up and I get NaN on the totals field. Anyway to get around this? Perhaps I could strip the values after the £ sign and do it that way? Not sure though?

Any ideas guys?