Format Currency

[William Morgenweck]

I'm using  type="number" format="C2"  but that give the display of $123,456.00  Exactly what it should.  But is there a way to format it without the .00 on the end?

Thanks

[Sujith Kumar Rajkumar]

Hi William, 

 

Greetings from Syncfusion support. 

 

You can achieve your requirement of displaying the number column with currency format and no decimals by setting the column format as – “C” as demonstrated in the below code snippet, 

 

<e-column field='Freight' format='C' width=90></e-column> 

 

More details on number formatting in Grid columns can be checked in the below help documentation link, 

 

https://ej2.syncfusion.com/vue/documentation/grid/columns/columns/#number-formatting 

 

Please get back to us if you require any further assistance. 

 

Regards, 

Sujith R 

[William Morgenweck]

I still get decimals

 <e-column field="award_amount" headerText="award_amount" width="150" format="C" ></e-column>

This is the data in the JSON data

"award_amount": 1450097,

but it shows as $1,450,097.00

I would like to show  $1,450,097

Thanks

[Sujith Kumar Rajkumar]

Hi William, 

 

Sorry for the inconvenience caused. 

 

Please set the format as – ‘C0’ for displaying currency values with no decimals in Grid column. 

 

We have also prepared a sample to demonstrate this case for your reference. You can find it below, 

 

Sample: https://www.syncfusion.com/downloads/support/forum/173816/ze/GridWithCurrencyFormatColumn1594138887 

 

Let us know if you have any concerns. 

 

Regards, 

Sujith R 

[RobertDupree]

Thanks for the link.

[Rajapandiyan Settu]

Hi Robert,

You’re welcome.

Regards,

Rajapandiyan S

[RobertDupree]

Thanks for the warm wishes :)

[Suganya Gopinath]

Hi Robert,

If this post is helpful, please consider Accepting it as the solution so that other members can locate it more quickly.

Regards,

Suganya Gopinath.

[William Morgenweck]

Some how this is total spam--