I discovered this while using an Excel 2007 or 2010 .xlsm file. (I also saved the file as a 2013 .xlsx same result.) This does not happen in a new 2013 workbook.
Excel 2013 is rounding (as it should) when decreasing the amount of displayed digits in a cell. However, it is also truncating the data, which is NOT correct. There are internal functions to invoke if the user wants to use rounded data in future operations.
Ex.
Type: 1.9 in Cell A1
Decrease precision to display no decimals. Result: A1 = 2
Increase precision to display 1 decimal place. Result: A1 = 2.0
Increase precision to display 2 decimal places. Result: A1 = 2.00
View this thread
Excel 2013 is rounding (as it should) when decreasing the amount of displayed digits in a cell. However, it is also truncating the data, which is NOT correct. There are internal functions to invoke if the user wants to use rounded data in future operations.
Ex.
Type: 1.9 in Cell A1
Decrease precision to display no decimals. Result: A1 = 2
Increase precision to display 1 decimal place. Result: A1 = 2.0
Increase precision to display 2 decimal places. Result: A1 = 2.00
View this thread