Hi,
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,
[AS]
"£ "+price
[/AS]
But, when calculating totals I need to do this:
[AS]
Number(quantity)*Number(price)
[/AS]
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?
Cheers,
Chris
