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.

The dialog box launcher