Default Data Type

[Narayanan Sankaranarayanan]

Hi All,

When I open a .csv or .txt file in excel the default data type is General
(radio button).
Is there a way in Excel to change that as Text for all the columns?

Thanks in advance

Narayanan Sankaranarayanan

 

[Dave Peterson]

When you open those .csv files, you don't even get to see the text to columns
wizard.

But when you open .txt files, you can see that wizard.

When you're at the dialog asking for the format, click on the first field and
shift click on the right most. That'll select all the fields in between, too.

Then you can change them all to Text.

(Close as you can get, I think.)