# Currency in DataGrid

**URL:** <https://forum.kirupa.com/t/currency-in-datagrid/85515>\
**Category:** flash\
**Created:** [April 5, 2005, 11:46am UTC](https://forum.kirupa.com/t/currency-in-datagrid/85515 "2005-04-05T11:46:37Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![darthmahon](https://avatars.discourse-cdn.com/v4/letter/d/8491ac/32.png) [@darthmahon](https://forum.kirupa.com/u/darthmahon)\
**Post date:** [April 5, 2005, 11:46am UTC](https://forum.kirupa.com/t/currency-in-datagrid/85515/1 "2005-04-05T11:46:37Z")

</div>

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