2

Is it possible to format a number field to put in the commas separating thousands? So 1000000 becomes 1,000,000.

I found FormatNumber but it doesn't look like it does the trick. http://help.exacttarget.com/en-US/documentation/exacttarget/content/ampscript/ampscript_syntax_guide/utilities_ampscript_functions/#FormatNumber

Thanks!

3

I have done something similar to this before.

Try %%=FormatNumber([Your Field], "N0", en-US)=%%

|improve this answer|||||
2

Try this:

%%=formatnumber(@field,"#,###")=%%    

It will round up:

%%=v(formatnumber("1234.56","#,###")=%%    
yields
1,235    
|improve this answer|||||
1

%%=FormatNumber([Your Field], "N0", en-US)=%% will not work. You need to add quotes around the "en-US".

Example:

%%=FormatNumber([Your Field], "N", "en-US")=%%

If you want it to limit the number of decimal places just add a # after the "N" of places you would like. If you only put "N" with no number it will keep all the places in the original number.

You can see all the FormatNumber options here: https://developer.salesforce.com/docs/atlas.en-us.noversion.mc-programmatic-content.meta/mc-programmatic-content/FormatNumber.htm

|improve this answer|||||

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.