For example, where the cell value = 5760000
- apply the Custom cell format #,##0, (with a trailing comma) to display 5,760
- apply the Custom cell format #,##0,, (with 2 trailing commas) to display 5.76
This is very useful for balance sheets where millions and billions need to be converted to readable numbers.
To set a Custom format click Format -> Format Cells -> Number (tab) -> Custom
Type the format in the Type field.
To do the same thing in a pivot table, right click a cell in a column that you wish to format, select Value field settings then number. Apply the formatting that you require.