skip to Main Content

How to Convert Number to Round Up and Display Two Decimal Places (Excel 2010)

There may be times when a number (or result of a calculation) has more than two decimal places. You can tell excel to display only 2 decimal places, but the full number with all the decimal places will be displayed when you click on an individual cell. There is a way to get the worksheet to convert the number to 2 decimal places and round up.
Back To Top