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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |