Default data type for TXT and CSV files

  • Thread starter Narayanan Sankaranarayanan
  • Start date
N

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
 
D

Dave Peterson

See one response to your other post.

Narayanan said:
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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell data entering slow! 0
Adding data to MS Access from csv file 0
Default Data Type 1
How to Write EXCEL files from a FORTRAN Program ? 0
Default local file location - folder redirection slowness 0
Auto Open Macro of external .txt file based on cell reference 1
Access Lock File .LACCDB / Now shows as a notepad file 0
Embed the same Excel multiple times 0

Top