Allow me to insert things like 1-9 without automatically correcting to the date.
basically what the title says. This is a thorn in my side, as there's no existing type of cell format for this input.
1
vote
Anonymous
shared this idea
Hi,
You can do this already in Excel today – there are two ways:
1. You can type an apostrophe before the data you enter → ’1-9, and Excel will then not interpret that as a date (it will interpret it as Text).
2. If you format the cell as Text before typing the value in the cell, Excel will not interpret it as a date.
Hope that helps,
Dan [MS]