Difference between revisions of "Number Format Specifiers"

From Keyfax Wiki
Jump to: navigation, search
(Created page with "{| class="wikitable" |+Number Format Specifiers !Expression !Databox Value !Result !Comments |Number Format ("C") |"12345.678" |£12,345.68 |Converts the Value into Currency f...")
 
 
(One intermediate revision by the same user not shown)
Line 1: Line 1:
 
{| class="wikitable"
 
{| class="wikitable"
|+Number Format Specifiers
+
|+ style="text-align:left;" | Number Format Specifiers
 
!Expression
 
!Expression
 
!Databox Value
 
!Databox Value
 
!Result
 
!Result
 
!Comments
 
!Comments
 +
|-
 
|Number Format ("C")
 
|Number Format ("C")
 
|"12345.678"
 
|"12345.678"

Latest revision as of 12:24, 28 February 2018

Number Format Specifiers
Expression Databox Value Result Comments
Number Format ("C") "12345.678" £12,345.68 Converts the Value into Currency format
Number Format ("E") "12345.678" 1.234568E+004 Exponential formatting
Number Format ("G") "12345.678" 12345.678 General formatting
Number Format ("F2") "12345.678" 12345.68 Fixed-point formatting to 2 decimal places
Number Format ("N2") "12345.678" 12,345.68 Number formatting to 2 decimal places
Number Format ("N3") "12345.678" 12,345.678 Number formatting to 3 decimal places
Number Format ("N4") "12345.678" 12,345.6780 Number formatting to 4 decimal places
Number Format ("P0") "12345.678" 1,234,568% Percent formatting (multiplies by 100 and formats to specified number of places
Number Format ("(#####) #######") 01202733767 (01202) 733767 Telephone No. conversion. If the Number begins with zero, this will not be recognised, so (“(0####) ######”) can be used