Leading the way in Microsoft Office Development

Example 1 - £* #,##0.00;-£* '#,##0.00

If you want to have your currency symbols appearing on the left of the cell rather than to the left of the value, just include an asterisk and a space after the currency symbol when entering the custom number format.

The asterisk means to repeat the character and in this case it’s a space to fill the width of the column.

Example 2 - ###.#

Example 3 - #.000

Example 3 - #.???

Example 4 - # ???/???

Example 5 - #,

To display numbers in thousands or millions, create a number format that ends with one or two commas. For example, the format “0,” will display “2002” as 2.

To display a number format that displays thousands without showing the 3 zeros (e.g. 69,000 is shown as 69) use the custom format "0,".

Example 6 - #,,

Example 7 - ;[RED]"Error";0;[RED]"Error"

Example 8 - 0;-0;;@

Example 9 - @

Example 10 - @*>

Example 11 - ??????.??????

Decimal tabs in Word can be used to align a column of numbers at the decimal point even when there are varying numbers of digits.

This custom number format will align all the decimal points.

Just make sure you include enough question marks on either side of the decimal place to accommodate all your digits.

Example 12 - ;;;

You can hide numerical data in cells with the null format (;;;). Just apply a different format in order to view the numbers.

Example 13 - 0.00;;

You can hide negative or zero numbers with the number format "0.00;;".