Format numbers, dates, and times in your text and email templates

When inserting a merge field for a number, amount, date, or time, you can now add a format string to control exactly how the value is displayed.

• In the template editor, click the merge field icon and enter a format in the new Format String field, or click the format-helper button to pick from ready-made presets. For example:
  • Numbers: N0 → 1,234 · N2 → 1,234.56 · C2 → $1,234.56 · P0 → 12% · P2 → 12.34% · F2 → 1234.56
  • Dates: d → 6/4/2026 · D → Wednesday, June 4, 2026 · dd/MM/yyyy → 04/06/2026 · MM/dd/yyyy → 06/04/2026 · yyyy-MM-dd → 2026-06-04
  • Times: t → 2:30 PM · T → 2:30:45 PM · HH:mm → 14:30 · HH:mm:ss → 14:30:45
  • Date/time: g → 6/4/2026 2:30 PM · G → 6/4/2026 2:30:45 PM · s → 2026-06-04T14:30:45

• Currency amounts automatically use the document’s currency symbol or code.

• If no format is set, fields are shown using your regular Business Central display settings, so existing templates are unaffected.

• Regional conventions dictate whether a comma or dot is used to separate thousands and decimals. For instance, numbers will be 1,234.56 in the US and 1.234,56 in mainland Europe.