« Text manipulation 1 : Concatenation | Main | Basic Functions : CELL »
February 12, 2005
Rounding Numbers to Thousands and Millions
Often, in financial statements, we wish to express totals as 'Thousands' or 'Millions'. In Calc, we use custom formatting to do this.In the example below, we use the number 1234567 to illustrate how the custom formats affect how this is displayed.
Firstly, #,## controls the use of commas. Secondly, 0 controls the number of digits after the decimal point. Finally, the trailing commas control the rounding of the number to thousands and millions.
Posted by Dave at February 12, 2005 04:35 AM