How to correct a ##### error - Microsoft …
https://support.microsoft.com/en-us/office/how-to-correct-a-error-bf801d0a-2a6e-44bd-a70e-0f780ae8f11e
Press CTRL+SHIFT+# or CTRL+SHIFT+@ to quickly use the default date or time format. If numbers have too many decimal places, click Home > Decrease Decimal. If a cell displays ##### after you apply date or time formatting to it, the cell probably isn't wide enough to display the data.
Press CTRL+SHIFT+# or CTRL+SHIFT+@ to quickly use the default date or time format.
If numbers have too many decimal places, click Home > Decrease Decimal.
If a cell displays ##### after you apply date or time formatting to it, the cell probably isn't wide enough to display the data.
DA: 41 PA: 6 MOZ Rank: 79