Function

Description

A + B

Where either A and/or B are string values, they are concatenated.

FORMAT(A, B)

A is a numeric value to be formatted; B is a string describing the format to employ.

Standard formats:

E/e:        Scientific Notation (upper and lower case 'E')

F:                Floating point

G:                General: Floating point or scientific notation,        depending on value

N:                Floating point with digit grouping

Standard formats can be followed by a number to indicate precision. For example, “F2” indicates floating point style with two digits after the decimal point.

Fully customisable number formats are also available where:

 '0'        represents the corresponding digit, or '0' if there is none

 '#'        represents the corresponding digit

 '.'        represents position of the decimal separator

Other custom format options are available. See Microsoft .NET documentation for Double.ToString() for full details.