Feedback by UserVoice

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

Be able to turn off auto-conversion of fractions and words into dates

When I import data in the format of a fraction #/#, excel automatically converts this into a date. This is unnecessary and should not be a default operation. At least, there should be a simple way to undo this.

I work with biological data, and there are gene names like "Oct1", and these get converted into dates, causing errors in data analysis.

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 → ’Oct1, 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]

4 comments

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

Feedback and Knowledge Base