![]() Excel 2007 used the source cells' formats to format the results cell. I don't have Excel 2010 / 2013 to test and verify, but I believe this bug started in 2010. If the same process is done in columns C & D, changing the values in row 2 to 8 and 6 digits after 0., the results are percentage formats with 11 & 9 decimal places respectively. ![]() I must then change cell format to percentage, 1 decimal and double click the column to reset the widthī1: Enter 0.175, change format to percentage, 1 decimal place to display 17.5%ī2: Enter 0.1749793774 (10 digits after 0.), change format to percentage, 1 decimal place to display 17.5%Įxcel displays 3.062139104500%, format check shows percentage, 12 decimal places Verify the default cell format is General and that the Normal Style's number format is General.Ī1: Enter 0.175, change format to percentage, 1 decimal place to display 17.5%Ī2: Enter 0.174999379377994 (15 digits after 0.), change format to percentage, 1 decimal place to display 17.5%Įxcel re-formats column width to display 3.062489139114890%, format check shows percentage, 15 decimal places Here are my steps: in Windows 8.1 / Excel 365, open a new workbook. If this is not a bug, what is the solution as it probably is a bug, how do we get Microsoft to fix it? Excel formats the cell with the multiplication formula as percentage with (usually) 15 decimal places and widens the column width to display the result manually reformatting back to the source cells' format (percentage / 1 or 2 decimal places) and minimum column widths is an ongoing issue. I frequently multiply two cells formatted as percentage with either 1 or 2 decimal places.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |