Currency Formatting with 2 decimal places

[Anonymous]

Hi there,

We would like to input currency values as variable data for a large email send. The leads are generated via a local list, so a .CSV file, and we are using the currency token to pull the individual dollar amounts from that file. Unfortunately, the .CSV file removes trailing zeros on the currency values and Marketo is reading the exact number from the file. For example, $1.25 or $0.25 works fine. But, values such as $0.30 or $1.30 are read as $0.3 or $1.3 on the Test emails. We have not figured out a solution to keep the trailing zero in the .CSV file. Does anyone have a solution for this so we can include trailing zeros for those amounts?

Thanks!

[Grégoire_Miche2]

Hi Kerri,

You can use velocity script tokens.

-Greg

[Anonymous]

Hi Kerri Keohane​,

What program are you using to 'process' the csv file?

Are you using Excel? Did you try to mark that column as 'text' in Excel and then exporting as csv?

I think you have that column as 'number' and that's why Excel is removing the trailing zeros. If you tell Excel that it is to be treated as text, it would not do it.

Please feel free to reach out at Rajesh@BrightHooks.com if you have any questions. Hope this helps.

Rajesh Talele