Description: when value contains a lot of digits, General (default) format display only what is possible according to column width. In this case, when using buttons "Add Decimal Place" or "Delete Decimal Places", ### is displayed, because format is switch to "Number" (even if scientific format were used), and number of decimal places is calculated like if column had an infinite width. Steps to reproduce: 1. Enter a value with a large number of digits, like =PI()*1000, in a cell with General format, and default width of column: 3141.592654 is displayed 2. Hit "Delete Decimal Place" button Actual behaviour: ### is displayed because format is switch to "Number" with 9 decimal places, which is too big for the column width. Expected behaviour: 3141.59265 should be displayed. Bug is worst with scientific format: if value is =PI()*1E11 display is 3.1416E+011. Delete Decimal Place change in Number format with 2 decimal places
*** This bug has been marked as a duplicate of bug 85410 ***