To fix numbers formatted as text showing #### in cells, you need to make the column wider to display the cell contents. To do this, double-click the column header’s right edge, or drag it to the width you want.
Also you can try the below steps:
- Click the Home >
Dialog box button next to Alignment.
- In the Format Cells dialog box, check the Shrink and click OK to fit the box.
- It may also decrease the decimal places or shorten the date format. Click on the Home tab and then find the Decrease Decimal or Short Date options.
- If the date is in a longer format, you can click the Home > arrow next to Number Format and pick Short Date. It will allow you to enter the date in a short verbose way, for example, 10/16/2022.
