Share via

“Automatic Data Conversion” settings are gone

Anonymous
2024-05-22T17:11:10+00:00

I had the “Automatic Data Conversion” settings before. It allowed you to disable the removal of leading zeros, displaying long numbers as scientific notation, converting letters and numbers to dates, etc. I can no longer find this section. How to get the settings back?

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

5 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-05-23T01:45:07+00:00

    Could you share a screenshot of your issue?

    Which version of Excel you are using?

    0 comments
  2. Anonymous
    2024-07-25T08:50:31+00:00

    My Excel version details:

    1. Microsoft 365 Apps
    2. Version 2308 (build 16731.20738)
    3. Semi-Annual Enterprise Chanel

    Post with similar problem here

    P.S. BTW can't attach screens (tried png, jpg, bmp, tiff formats)

    Image

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2024-07-25T12:00:23+00:00

    Thank you so much for the reply! I didn't check the version of my excel files with issues. Our organization has switched to Microsoft 365 and as a result, the data setting shown in your 1st screenshot is back. The issues have been resolved.

    0 comments
  4. Anonymous
    2024-07-25T12:02:12+00:00

    The screenshots you posted are invisible to me. Thanks a lot for your reply though!

    0 comments
  5. Anonymous
    2024-07-25T15:32:09+00:00

    It's invisible for everyone, this problem is mentioned in comment... ;)
    Question: are you able to paste "visible" screenshot?

    For example, could you please edit your previous post and paste screen with your excel version?

    0 comments