Numberformat: Difference between revisions

From SMTX Wiki
Jump to navigation Jump to search
m 1 revision imported
No edit summary
 
Line 31: Line 31:


   FORMAT('{0:f2}', ToNumber('##',0))
   FORMAT('{0:f2}', ToNumber('##',0))
To request a Belgian account (bank) number:
  ^BE\d{2} \d{4} \d{4} \d{4}$
This will ensure a format: Formaat: BExx xxxx xxxx xxxx (BE2-4-4-4)

Latest revision as of 12:02, 2 July 2025

In 'default values', set the field as 'contains calculations' and add this

  FORMAT('{0:0.00}', TONUMBER('#REPLACE-FORMFIELD-DateChecks||roundnumber||#'))

The example above will transfer any number to a number with 2 digits after the decimal seperator, example:

12121211212.12212 becomes =>  12121211212.12

To force to show the thousands seperator , with 2 digits after the decimal seperator

 format('{0:N2}',##)

To force to show the thousands seperator , with 0 digits after the decimal seperator

 format('{0:N0}',

To show the number with decimal & thousands seperators, and leave blank without any entry, with 2 digits after the decimal seperator Note: the 2 single quotes at the end gives the alternative input, so in this case it remains empty when nothing is entered. View this page in EDIT mode to see the quotes !!!

 FORMAT('{0:N2}', tonumber('#REPLACE-FORMFIELD-Numbers example||Amount_02||#', ))


To show the number with decimal & thousands seperators, and leave blank without any entry, with 5 digits after the decimal seperator Note: the 2 single quotes at the end gives the alternative input, so in this case it remains empty when nothing is entered. View this page in EDIT mode to see the quotes !!!

 FORMAT('{0:N5}', tonumber('#REPLACE-FORMFIELD-Numbers example||Amount_02||#', ))

To show a number, without thousands seperator, but with 2 digits after the comma (decimal seperator):

 FORMAT('{0:f2}', ToNumber('##',0))

To request a Belgian account (bank) number:

 ^BE\d{2} \d{4} \d{4} \d{4}$

This will ensure a format: Formaat: BExx xxxx xxxx xxxx (BE2-4-4-4)