Adding Thousand Separators (FIXED)
Syntax: FIXED(Number; Decimal_Places; No_Commas)
The FIXED function converts the given number into comma-separated text format. For example:
=FIXED(1000000; 2)
returns 1,000,000.00 unless you put 1 as the third argument to switch commas off.
Figure 10-3. Sample result of the FIXED function
The second argument, decimal_places, is used to specify the number of decimal places. For an idea on how to use this function, see DOLLAR.
Get Beginning OpenOffice Calc: From Setting Up Simple Spreadsheets to Business Forecasting now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
