Fucntion variables format numbers function
 ArborX

Summary
 Examples of patters.

Examples:
 ^[format_num 1234567,"#,###"]

Will output 1,234,567.

Number

Format Pattern

Result

12345

#,##0.00

12,345.00

1234.5

#,##0.00

1,234.50

123.456

#,##0.00

123,46

1234

###0.0###

1234.0

123.45

00000.000

00123.450

0.25

#00%

25%

1234

###0.0###

1234.0

12.34

£#.00CR;£#.00OD

£12.34CR

-12.34

£#.00CR;£#.00OD

£12.34OD

Document created on 22-Nov-2004 (revision 1)