Limit / Set Decimal Places in Spreadsheet

How to limit or set decimal places in OpenOffice Spreadsheet?


We have two option to limit decimal places for a number in a cell using the format cells window.
Step 1: Open the format cells dialog box. Press Ctrl+1 (Shortcut) and for other methods of opening the format cells,Click here
Step 2:In the format cells dialog box, under the Numbers tabCategory → click Number and increase or decrease the Decimal places value as required and press OK.
Select Decimal Places in Spreadsheet

Related Topics