David Morris
New Member
 Joined
 Feb 15, 2020
 Messages
 8
 Office Version

 365
 Platform

 Windows
I frequently multiply two cells formatted as percentage with either 1 or 2 decimal places. 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. If this is not a bug, what is the solution; as it probably is a bug, how do we get Microsoft to fix it?
Here are my steps: in Windows 8.1 / Excel 365, open a new workbook. Verify the default cell format is General and that the Normal Style's number format is General.
A1: Enter 0.175, change format to percentage, 1 decimal place to display 17.5%
A2: Enter 0.174999379377994 (15 digits after 0.), change format to percentage, 1 decimal place to display 17.5%
A3: Enter formula =A1*A2
Excel reformats column width to display 3.062489139114890%, format check shows percentage, 15 decimal places
I must then change cell format to percentage, 1 decimal and double click the column to reset the width
B1: Enter 0.175, change format to percentage, 1 decimal place to display 17.5%
B2: Enter 0.1749793774 (10 digits after 0.), change format to percentage, 1 decimal place to display 17.5%
B3: Enter formula =B1*B2
Excel displays 3.062139104500%, format check shows percentage, 12 decimal places
I must then change cell format to percentage, 1 decimal and double click the column to reset the width
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 don't have Excel 2010 / 2013 to test and verify, but I believe this bug started in 2010. Excel 2007 used the source cells' formats to format the results cell.
I googled sitemrexcel.com "15 decimal places" and learned that on Jan 10/14, Smitty answered a similar question by saying this was default behavior with unrecalled logic, while on Jul 1/14, RoryA wrote that it sounds like abug.Over the last couple of years, I have googled about this issue many times and learned that this is indeed a bug. It literally bugs me as I have many workbooks with formulas multiplying 2 percentages and have to constantly reformat both cells and column widths. Any and all help is appreciated. If not, I may have to revert to Excel 2007.
Here are my steps: in Windows 8.1 / Excel 365, open a new workbook. Verify the default cell format is General and that the Normal Style's number format is General.
A1: Enter 0.175, change format to percentage, 1 decimal place to display 17.5%
A2: Enter 0.174999379377994 (15 digits after 0.), change format to percentage, 1 decimal place to display 17.5%
A3: Enter formula =A1*A2
Excel reformats column width to display 3.062489139114890%, format check shows percentage, 15 decimal places
I must then change cell format to percentage, 1 decimal and double click the column to reset the width
B1: Enter 0.175, change format to percentage, 1 decimal place to display 17.5%
B2: Enter 0.1749793774 (10 digits after 0.), change format to percentage, 1 decimal place to display 17.5%
B3: Enter formula =B1*B2
Excel displays 3.062139104500%, format check shows percentage, 12 decimal places
I must then change cell format to percentage, 1 decimal and double click the column to reset the width
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 don't have Excel 2010 / 2013 to test and verify, but I believe this bug started in 2010. Excel 2007 used the source cells' formats to format the results cell.
I googled sitemrexcel.com "15 decimal places" and learned that on Jan 10/14, Smitty answered a similar question by saying this was default behavior with unrecalled logic, while on Jul 1/14, RoryA wrote that it sounds like abug.Over the last couple of years, I have googled about this issue many times and learned that this is indeed a bug. It literally bugs me as I have many workbooks with formulas multiplying 2 percentages and have to constantly reformat both cells and column widths. Any and all help is appreciated. If not, I may have to revert to Excel 2007.