To change the format of the cell, follow the instructions written below: After that, Excel will display the decimal number without rounding it up to the decimal places you have selected.

When you type a seven-or-ten-digit phone number into an Excel cell that uses the phone number format, Excel will automatically change the way the number looks so that it appears as a phone number.

Use numeric formatting to override Excel's defaults and specify that your numbers appear with all their decimal places visible. Click on a cell to select it, or click and drag through a series of ...