Select Number from the list.
In the Decimal Places box, specify the precision of the number. You can have a minimum of 0 and a maximum of 15.
Select the Thousands with Commas checkbox for comma formatted numbers i.e. 1,345,622 rather than 1345622.
Select the Negatives in Brackets checkbox to enclose negative numbers in brackets i.e. (123456) rather than -123456.
Select the Negative in Red checkbox to display negative numbers in red font.
In the Trail/Lead String option you can choose to have either trailing or leading characters. Enter your text in the text box or choose from the existing group ($, £, DM, cm, kg, etc.). You can create your own number formats, including alternative currency formats. Here are some examples:
1.2 $bn
FFr 23.56
DMarks
Check that the options you have chosen are correct by glancing at the Preview box and then click on OK.
See: