Taking the number 1234.56:

You can use the "." character to set the position of the decimal separator and "," for the thousands separator.

• {0:0.000} = 1234.560
• {0:#,0.00} = 1,234.56
• {0:#,0.####} = 1,234.56
• For scaling larger numbers (using 123000000):
  • {0:#,0} = 123,000,000
  • {0:#,0, K} = 123,000 K
  • {0:#,0,, M} = 123 M

It is also possible to specify different formats for positive, negative and zero numbers by separating those different formats with the ";" character.

Using the negative number -1234.56:

• {0:0.00} = -1234.56
• {0:0.00;(0.00);0} = (1234.56)
• {0:0.00;'neg: '-0.00;zero} = -1234.56

Using the number 0:

• {0:0.00} = 0.00
• {0:0.00;(0.00);0} = 0
• {0:0.00;'neg: '-0.00;zero} = zero

Any other non-special characters not used in formatting are written exactly as specified in the output. If you need to include exact text that does include formatting characters then that must be inserted between two single quotes.

Using the number 1234.56:

• {0:0.00 Example} = 1234.56 Example
• {0:0.00 #Example.} = 1234.56 Example
• {0:0.00 '#Example.'} = 1234.56 #Example.