Home
PageNumericFormat
This assigns a numeric format for the current page or resets the default for the project. Any data column which does not have a specifically assigned format will use this format.

Syntax:

PageNumericFormat, [*]formatString

Parameters:

 * -- optional flag to format only columns with values less than 1

formatString – Change the display to show a specific numeric format { C#, E#, F#, G, N#, P#, R# }

Examples:

PageNumericFormat,N2

Change the current page to display regular numeric columns with two decimal places.

PageNumericFormat,*G

Change the current page to display integers in columns > 1, but flip to General format for columns with values less than 1.

Comments:

Data columns are normally double values so they have very high level of precision.  The assignment of a numeric format will result in altered numbers in the display only, but numeric formats are used during export to CSV, as well as being supplied to some situations when the data is exported to a database. Percentage formatting multiplies the number by 100 for display. For more information, see: Standard Numeric Format Strings in MSDN reference library: http://msdn2.microsoft.com/en-us/library/dwhawy9k.aspx
 
< Prev   Next >

Reference