To stop Google Sheets from rounding numbers, you’ll need to adjust the number formatting for the cells in question. Here’s how to do it:
1: Select the cells that you want to format.
2: Click the “Format” option in the top menu, then click “Number” from the dropdown menu.
3: In the Number Formatting window that appears, click on the “Custom” option.
4: In the field next to “Type,” enter the number of decimal places that you want to display. For example, if you want to display numbers with two decimal places, you would enter “0.00”.
5: Click “Apply” to apply the formatting to the selected cells.
That’s it! Your numbers should now be displayed with the number of decimal places that you specified, and they shouldn’t be rounded.