Currency

This is exactly the same as the general format except that you can also select a currency symbol to precede (or succeed) the value.
This is the format used to display general monetary values.

alt text

Decimal places - The number of decimal places is from 0 to 30.
Symbol - There are over 350 possible currency symbols to choose.
Negative Numbers -
The thousand separator is always displayed.


How it is different to the Number format

This number format is like the Number format but with two differences:
You can choose a currency symbol (which will be displayed before the actual number).
This format always includes a comma seperator.


Formatting Toolbar Button

This number format can be quickly applied by pressing the following button on the Formatting toolbar.

alt textCurrency Style - Applies the currency format "£#,##0.00".

All Numbers in Black

Default currency button on the toolbar ??

alt text

Negative Numbers in Red


alt text

Negative Numbers in Parentheses


alt text

Negative Numbers in Red with Parentheses


alt text


© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited TopPrevNext