Value formatting
Format raw numeric values
Merge the report to turn plain JSON numbers into template-defined currency and decimal representations.
Understand the current template
Explore its merge fields, repeating blocks, and nested structure in an interactive template map.
Ready to tryUse the controls above to interact with this demo.
What this demonstrates
Keep values typed and presentation flexible
The JSON contains numbers such as 249.56, not preformatted strings. Numeric format switches stored in merge fields control currency symbols, decimal digits, and separators in the generated document.
The controller sets explicit source and output cultures so the result remains deterministic regardless of the server's regional settings.
API used
MailMerge.MergeCulture
How it works
MergeJsonData preserves numeric values. MailMerge applies the format encoded by each field using the configured en-US output culture before saving the document.