Feedback by UserVoice

How can we improve Excel for Windows (Desktop Application)?

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
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

Anonymous shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
already supported  ·  Dan Battagin [MS XL] responded  · 

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]

0 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base