If the negative date and/ or time value is a result of a calculation, then check the formula to rule out any errors that may be causing this. Check Formula to Avoid Negative Date or Time Value as a Result of Computation
If it was by accident, then, of course, the easiest solution would be to remove the minus sign and change the negative value to positive, provided it does not affect subsequent calculations. The minus sign could have been added by mistake or could be the result of a calculation. Solution – Verify that Date and Time are Positive Values It fills the entire cell with the hash sign, so if you adjust the column width, you will still see the hash symbols. So if you have a cell where you want to show date or time as negative, Excel revolts and shows the content as hash symbols. Problem 2: Your Cell Contains Negative Date or Time Valuesĭate and Time in Excel can not be negative. Position your mouse pointer over the right edge of the column, till it turns into a double-ended arrow. The quickest and easiest way to fix the problem is to move the mouse cursor to the header where the individual letters appear for each column. Solution 1 – Increase the Width of the Column Sometimes when the content of a cell is longer than what the column can display, it ends up showing the # (hash symbols).Īll the solutions for this issue would involve fitting the content of the cell within it. Here are some things you can try out to solve the problem: Problem 1: Your Column is too Narrow to Display the Contents of the Cell
#Excel meaning series#
You can follow a series of steps to narrow down to the source and correct it. In both cases, it is possible to work through and get rid of the symbols. Your cell might contain negative date or time values.Your column might be too narrow to display contents of the cell.The # appears in a cell for two possible reasons: Possible Reasons you are Seeing the # Symbol (Pound/Hash Symbol) Solution – Verify that Date and Time are Positive Values.Problem 2: Your Cell Contains Negative Date or Time Values.Solution 3 –Decrease Decimal Places in Numbers.Solution 2 –Shrink Contents of the Column.Solution 1 – Increase the Width of the Column.Problem 1: Your Column is too Narrow to Display the Contents of the Cell.Possible Reasons you are Seeing the # Symbol (Pound/Hash Symbol).