Output Currency

1

Hi Team,

We want to convert values into currency format. We can see that there are various formats that we can convert a numeric value to but couldn’t find something for currency for e.g. $

Regards,
Sumit

2

Welcome to the Community, Sumit!

EasyMorph doesn’t have a designated data type/format for currency. Formatting depends on where you want to further export the data.

If you’re exporting into a text file, then you simply can create a text column with necessary formatting, for instance:

"$" & round([Amount],2)

If you export into a database, then no additional formatting is required if the target column has a currency formatting.

3

Hi,

Thanks for your response. This works for spreadsheets. I am assuming this would do for other data sources such as Access, SQL databases as well.

Thanks again!

4

You’re welcome!