#### David Morris

##### New Member

- Joined
- Feb 15, 2020

- Messages
- 8

- Office Version
- 365

- Platform
- Windows

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 re-formats 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 un-recalled 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.