If you liked our blogs, share it with your friends on Facebook. You need to increase the column width to view the content of the cell.Ĭonclusion: The above four detailed explanations are the possible reasons for showing hash error instead of text or numbers. Changing the font to large size excel may not be able to display the value of the cell & hence shows hash error in excel. One should also keep in mind that excel shows # sign instead of text due to increase in font size of the cell.

You can check the format settings refer below image: You can refer to below image in which cell A2 & B2 both contains same date with same formats but one cell is visible while the other one is not getting displayed. Sometimes, the date format is set in a lengthy format, like “October 1, 2015”.

All we need to do is increase the width of the cell by mouse or keyboard shortcut “ALT + O + C + A”Įxcel is designed to contain dates within range through if user is trying to enter dates outside this range then # error will get displayed. In above image, the cell value contains date as which is getting displayed in Formula Bar box. The possible reasons are:įirst one is that the cell width is not wide enough to display the content of the cell.Įxample: the cell contains a date value & the cell width is narrow. There can be multiple answers to this problem. Question: Sometimes, excel cell displays a series of # characters instead of value or text. To know more about each tab individually, click on the link: There are six tabs in the Format Cells dialog box: The other shortcut is “SHIFT + F10” keys and will work as right clicking on mouse does & then you can simply select Format Cells from the shortcut menu. The shortcut to launch Format cells dialog box is “CTRL + 1” there’s no need to use mouse hence, you can save your precious time. Format Cells is the most used feature of excel when it comes to formatting a cell value from General format to Number, Currency, Accounting, Date & so on.

Number dialog box launcher excel mac