How do I fix ## in Excel? [Microsoft 2016]

By Samrat Biswas

How do I fix ## in Excel

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.

Leave a Comment