Excel date problem

[jokos12385]

Some of my numbers turn into dates when I try to import them. Is there anyway around this problem?

I have 500k+ rows with data, so looking through each and every cell is not an option.

 

[Andrew Poulsom]

Welcome to MrExcel.

You can specify the format of the column at Step 3 of the Text Import Wizard. It sounds like you need Text.

 

[jokos12385]

Thank you! Life saver