I use Excel in Office 365. When I enter a calculation in a cell, the cell being formatted at %, Excel automatically expands the numebr decimals and widens the column width. How can I stop this? I notices when I look into number formats, custom formats there is a custom % format with over 10 decimals. I deleted this custom format. The I entered the same calculation and again Excel expands the decimals and widens the column. When I check custom number formats, Excel has added back the % format with over 10 decimals. How can I stop Excel from adding decimals and widening the column?
Solved by C. C. in 17 mins