https://wiki.smt-x.com/index.php?action=history&feed=atom&title=Numberformat
Numberformat - Revision history
2026-04-03T23:04:42Z
Revision history for this page on the wiki
MediaWiki 1.44.3
https://wiki.smt-x.com/index.php?title=Numberformat&diff=1025&oldid=prev
Smtxwiki at 10:02, 2 July 2025
2025-07-02T10:02:08Z
<p></p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 12:02, 2 July 2025</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l31">Line 31:</td>
<td colspan="2" class="diff-lineno">Line 31:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div> FORMAT('{0:f2}', ToNumber('##',0))</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div> FORMAT('{0:f2}', ToNumber('##',0))</div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">To request a Belgian account (bank) number:</ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> ^BE\d{2} \d{4} \d{4} \d{4}$</ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">This will ensure a format: Formaat: BExx xxxx xxxx xxxx (BE2-4-4-4)</ins></div></td></tr>
</table>
Smtxwiki
https://wiki.smt-x.com/index.php?title=Numberformat&diff=175&oldid=prev
Smtxwiki: 1 revision imported
2020-05-25T20:44:29Z
<p>1 revision imported</p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<tr class="diff-title" lang="en">
<td colspan="1" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="1" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 22:44, 25 May 2020</td>
</tr><tr><td colspan="2" class="diff-notice" lang="en"><div class="mw-diff-empty">(No difference)</div>
</td></tr></table>
Smtxwiki
https://wiki.smt-x.com/index.php?title=Numberformat&diff=174&oldid=prev
Smtxwiki at 09:51, 28 February 2017
2017-02-28T09:51:22Z
<p></p>
<p><b>New page</b></p><div>In 'default values', set the field as 'contains calculations' and add this <br />
FORMAT('{0:0.00}', TONUMBER('#REPLACE-FORMFIELD-DateChecks||roundnumber||#'))<br />
<br />
The example above will transfer any number to a number with 2 digits after the decimal seperator, example:<br />
<br />
12121211212.12212 becomes => 12121211212.12<br />
<br />
To force to show the thousands seperator , with 2 digits after the decimal seperator<br />
<br />
format('{0:N2}',##)<br />
<br />
To force to show the thousands seperator , with 0 digits after the decimal seperator<br />
<br />
format('{0:N0}',<br />
<br />
To show the number with decimal & thousands seperators, and leave blank without any entry, with 2 digits after the decimal seperator<br />
Note: the 2 single quotes at the end gives the alternative input, so in this case it remains empty when nothing is entered.<br />
View this page in EDIT mode to see the quotes !!!<br />
<br />
FORMAT('{0:N2}', tonumber('#REPLACE-FORMFIELD-Numbers example||Amount_02||#','' ))<br />
<br />
<br />
<br />
To show the number with decimal & thousands seperators, and leave blank without any entry, with 5 digits after the decimal seperator<br />
Note: the 2 single quotes at the end gives the alternative input, so in this case it remains empty when nothing is entered.<br />
View this page in EDIT mode to see the quotes !!!<br />
<br />
FORMAT('{0:N5}', tonumber('#REPLACE-FORMFIELD-Numbers example||Amount_02||#','' ))<br />
<br />
To show a number, without thousands seperator, but with 2 digits after the comma (decimal seperator):<br />
<br />
FORMAT('{0:f2}', ToNumber('##',0))</div>
Smtxwiki