Format Number to String

Sometimes it can be useful to display a number in a specific format - to make it easier to read and understand. 

For example, if we have the number 1000000000 it can be hard for someone to work out how large this number is.

There is a FormatNumber(number, format) function that allows you to specify what the output should look like.

=FormatNumber(1000000000, '0 a') // = 1 B

You can use the following reference to understand what each format type will result in.

Number Format String
10000 '0,0.0000' 10,000.0000
10000.23 '0,0' 10,000
10000.23 '+0,0' +10,000
-10000 '0,0.0' -10,000.0
10000.1234 '0.000' 10000.123
100.1234 '00000' 00100
1000.1234 '000000,0' 001,000
10 '000.00' 010.00
10000.1234 '0[.]00000' 10000.12340
-10000 '(0,0.0000)' (10,000.0000)
-0.23 '.00' -.23
-0.23 '(.00)' (.23)
0.23 '0.00000' 0.23000
0.23 '0.0[0000]' 0.23
1230974 '0.0a' 1.2m
1460 '0 a' 1 k
-104000 '0a' -104k
1 '0o' 1st
100 '0o' 100th
Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.