...
This format is the same as the word option. This format uses the characters '$', '#', ',', '.', '0' to define the format of the number.
Here are some examples:
Code | Input | Result |
0,000.0 | 123 | 0,123.0 |
$00.00 | 123.456 | $123.47 |
####.# | 123.456 | 123.4 |
0## | 123.4 | 123 |
If you would like to learn more about this format or more specifically the format strings we user internally visit https://msdn.microsoft.com/en-us/library/0c899ak8(v=vs.110).aspx .