FPCH Admin AWS Posted April 18, 2013 FPCH Admin Posted April 18, 2013 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 Quote Off Topic Forum - Unlike the Rest
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.