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:
- 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.
- Right-click on your range and select Format Cells or press CTRL + 1 (one).
- Select Text in the Category list on your Number tab.
- Click OK.
That is really all there is to it! Now we have all learned something new about Excel!