Forum Discussion
Solved
Excel wiill not treat the entry 11-11-11 as a text entry. It keeps treating it like a date.
I wish to add the entry 11-11-11 as a title for a movie. I then wish to be able to enter this in Excel without it being changed to a date or treated as a number. And then be able to sort this with...
- I have found an answer to my specific problem.
I place 11-11-11 in a cell
I format the cell as a Number then Custom then as Type 11-11-11.
This permits 11-11-11 to be shown without the green triangle and more importantly allows the column this cell is in to be sorted without generating a Sort error.
I find those green error triangles irritating. I have turned them off by clearing all the check boxes in the Error Checking section of File > Options > Formulas.
A date is a number in Excel, and Excel recognizes 11-11-11 as a possible date, hence the warning.
I have found an answer to my specific problem.
I place 11-11-11 in a cell
I format the cell as a Number then Custom then as Type 11-11-11.
This permits 11-11-11 to be shown without the green triangle and more importantly allows the column this cell is in to be sorted without generating a Sort error.
I place 11-11-11 in a cell
I format the cell as a Number then Custom then as Type 11-11-11.
This permits 11-11-11 to be shown without the green triangle and more importantly allows the column this cell is in to be sorted without generating a Sort error.