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.
#WHERE IS DIALOG BOX LAUNCHER SERIES#
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.