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
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    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]

    3 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...

      Feedback and Knowledge Base