More On Automatic Formatting In Excel

It seems I did not do enough research on the above subject. All I addressed was importing issues. Now I will tell you how to avoid data formatting that is now imported.

Apparently, the problem arises once you decide to go a different path than the typical Excel way. Most often, this is when we have large data sets in our worksheets. When you enter numbers with dashes or slashes, Excel will arbitrarily decide those are dates or times, etc. Can you cancel automatic formatting? No! However, there is one way to deal with this issue.

Follow the steps below to learn how:

  1. Select the range where you will have your data, It can be one column or several. If you like, you can select your entire worksheet. Of course, that is easy to do by pressing Ctrl + A.
  2. Right-click on your range and select Format Cells or press CTRL + 1 (one).
  3. Select Text in the Category list on your Number tab.
  4. Click OK.

That is really all there is to it!  Now we have all learned something new about Excel!

3 thoughts on “More On Automatic Formatting In Excel”

  1. Sometimes my Excel Pro 2016 makes changes to a cell, like:
    o changing from my selected color to a different one that I did not select
    o changing from not underlined to underlined
    o changing from italicized to not italicized
    o changing font size

    This happens immediately after I finish typing my cell entry.
    But if I UNDO (via CTRL-Z) it returns to my original intended entry.
    Any idea why this randomly happens?

  2. Hi Dan,

    I cannot tell you why that is happening as you are using a different version of Excel than I. Did you try what I said in my article? I am not sure that will work for you but it certainly is worth a try.

    Thank you for your interest in my articles.


Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top


Get great content like this delivered to your inbox!

It's free, convenient, and delivered right to your inbox! We do not spam and we will not share your address. Period!