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 tab → Category → click Number and increase or decrease the Decimal places value as required and press OK.