3

This question already has an answer here:

How can I stop Microsoft Excel from auto formatting data when imported from a csv/text file? Specifically, I want it to treat all of the values as text.

The files come to me as tab delimited text files. When loaded/opened in Excel, Excel auto-formats the data causing leading 0's on values to be truncated and often converting the values into dates.

We do not want to click through the import wizard an specify that each column is text. We would rather open the .csv file and have it be handled accordingly.

Ideally I just want to turn off Excel's Auto-Formatting completely, and just edit every cell as it were plain text. There are no formulas to be concerned with.

This is NOT an Auto Correct or "Replace text as you type" problem so it doesn't appear to be addressable by the AutoCorrect panel.

marked as duplicate by Pimp Juice IT, Overmind, mdpc, fixer1234, DavidPostill Jun 10 '17 at 17:21

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

  • 2
    This may be best solved with a little vba script that and a QuickAccess Toolbar button. – Adam Mar 23 '17 at 18:33
1

By using Import Text File Wizard, you can choose data type for each column.

  • I agree that this avoids the problem, but OP explicitly asked for some way to automate this process... "We do not want to click through the import wizard an specify that each column is text. " – Wouter Jun 7 '17 at 14:40

Not the answer you're looking for? Browse other questions tagged or ask your own question.