How can I represent my integer numbers with commas to separate numbers? | Community
Skip to main content
A
Anonymous
June 25, 2013
Question

How can I represent my integer numbers with commas to separate numbers?

  • June 25, 2013
  • 4 replies
  • 3219 views
I'm using a mail merge with an integer as the field type for the token. It's pulling in the data from Salesforce where the commas to separate the 1000s are appearing fine. Unfortunately with the pulling into Marketo, the commas are gone and it appears like a plain string of numbers i.e. 123432 instead of 123,432. Thanks!
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

4 replies

A
Anonymous
June 25, 2013
Check this out; if you're not code inclined may need to have your web dev check it out for you:

http://stackoverflow.com/questions/1990512/add-comma-to-numbers-every-three-digits-using-jquery
A
Anonymous
June 25, 2013
Jason can you explain more how this would work in an email?
A
Anonymous
June 25, 2013
Unfortunately Integer type fields do not have commas.  You would need to use a Float type field for this.  You should be able to change the type of your existing field in Field Management.

A
Anonymous
July 17, 2015

So... it's 2015 and I'm having the same problem... :-) Really need to use the thousand comma separator as we'd like to use tokens to pull fields with 4 to 10 digits numbers. Our email are looking sloppy without the comma separator (1,223,333 looks a lot better and is a way more legible than 1223333).

I have changed the field from 'Integer' to 'Float' and it still doesn't work. I have test importing these fields as 'text' and 'number' on the csv file and it didn't work either way.

Hope someone can help!

Cheers,

Maísa

A
Anonymous
July 28, 2015

I've got an answer for this and I can confirm that Float can't translated the thousand comma separator on emails. The correct field type must be 'String'.

The values will need to be converted as text on Excel, and you might need to use the formula below to add the commas: =TEXT(B2,"#,###,###")

Cheers,

Maísa

    Terms & ConditionsAccessibility statement

    Loading footer...