How to format with 1 decimal whenever number between -10 and 10, but no decimal when greater than 10 or lesser than -10. For example 9.9 we show one decimal, but 10 comes rounded with no decimal.

The number of zeros corresponds to the number of decimal places. As an example, ".00" displays the number "0.349" as ".35." Click "OK" to apply the custom format to the selected cells.

If you are just looking to get rid of the numbers after the decimal point, using the INT function with your RAND function should do the trick. Open a new Microsoft Excel 2010 spreadsheet.

Microsoft Excel is a widely used spreadsheet software that allows users to perform various calculations and analysis on data. One of the essential features of Excel is the ability to format numbers, ...