Why do appear in excel

Yes No. Thank you! Any more feedback? The more you tell us the more we can help. Can you help us improve? Resolved my issue. Clear instructions. Easy to follow. No jargon. Pictures helped. Sometimes, when you enter a formula into Excel, the cell simply shows , instead of the expected value.

This problem most commonly occurs because the cell is not wide enough to display the value that it has calculated. Some cell formats e. However, some formats e. If the cell is not wide enough, it will display a row of hashes. This problem is easily solved, by altering the cell width.

This error occurs when there is nothing missing in the cell, it's just that there isn't enough space for the new or updated value.

As per Microsoft official site a error is Excel's way of saying that the cell width isn't enough for the length of the value. The most basic reason for the hashtag error is when the formula used in the cell returns a decimal number which cannot fit in the cell width. Generally Excel function returns a decimal number and lack of space for the cell value shows the error.

Here, a error suggests that the width of the cell needs to increase or the decimal value can be shortened. See the below example to understand more. For example, the mathematical PI function returns the irrational value up to 8 to 9 decimal digits. Look in the above snapshot and realize the what excel does with the result.

In order to get the adjustment of the cell value in cell. The option just allows the cell value to replace error to actual value. In the above gif the value is retained. Follow the below explained steps to avoid errors. In the gif shown below only the formula is used. Follow the below steps to avoid having hashtag error. Follow these steps to avoid the hashtag error. As you can see the hashtag Error can be handled when you use the above mentioned suggestions.

Another reason for the hashtag error is when the long Date value cannot fit in the cell width. Generally Excel long data format and lack of space for the cell value shows the error. Here, a hashtag error suggests that the width of the cell needs to be increased or the date value can be shortened.