# Table Column numberFormat for Euro?

**URL:** <https://forum.inductiveautomation.com/t/table-column-numberformat-for-euro/63789>\
**Category:** Ignition\
**Tags:** ignition81, perspective\
**Created:** [September 6, 2022, 4:44pm UTC](https://forum.inductiveautomation.com/t/table-column-numberformat-for-euro/63789 "2022-09-06T16:44:48Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Curtis\_Turley](https://avatars.discourse-cdn.com/v4/letter/c/d78d45/32.png) [@Curtis\_Turley](https://forum.inductiveautomation.com/u/Curtis_Turley)\
**Post date:** [September 6, 2022, 4:44pm UTC](https://forum.inductiveautomation.com/t/table-column-numberformat-for-euro/63789/1 "2022-09-06T16:44:48Z")

</div>

Hello,

I am trying to get numberFormat in table.props.columns.0 to display a number in dollars or euros, depending on a binding. Since the table is editable, I would rather not render it as a string and format that. I have tried putting the euro symbol in the format string but it does not seem to recognize it.

From what I can tell, numberFormat uses Numeral.js which can only change it’s currency symbol if the locale is changed. I tried changing the locale in the designer, which did not seem to do anything. Even if it did, that doesn’t seem like a great solution. Does anybody know of a way to do this?

Thanks,

Curtis

---

<div class="post-metadata">

**Author:** ![justinedwards.jle](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/justinedwards.jle/32/37854_2.png) [@justinedwards.jle](https://forum.inductiveautomation.com/u/justinedwards.jle)\
**Post date:** [September 7, 2022, 2:15am UTC](https://forum.inductiveautomation.com/t/table-column-numberformat-for-euro/63789/2 "2022-09-07T02:15:04Z")

</div>

I see what you mean. The number renderer removes the character even with the euro is properly quoted ‘€’  
Changing the session local to places in Europe had no effect for me either

---

<div class="post-metadata">

**Author:** ![justinedwards.jle](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/justinedwards.jle/32/37854_2.png) [@justinedwards.jle](https://forum.inductiveautomation.com/u/justinedwards.jle)\
**Post date:** [September 11, 2022, 11:44pm UTC](https://forum.inductiveautomation.com/t/table-column-numberformat-for-euro/63789/3 "2022-09-11T23:44:19Z")

</div>

I figured out a work around.  
I added an extra column just before the currency column and selected date for the renderer. In the date format, I used this binding expression: `if ({../Checkbox.props.selected},'€','$')`  
In the actual currency column, I used this for the number format: `(0,0.00)`  
Here are the column parameters  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/2/928cb0cd633e35d1b211945ab9a04aabf4ffeb53.png)  
The key parameters are {justify: right, width: 10, strictWidth: True, header Title: " "}

**This is the result:**  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/2/32e0b178b359e102b94401bb53a4d018e4932222.png)  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/0/9/09df325f9aa996cb6fa741b89202c9c6febe3bdf.png)