how to force a column to TEXT?

  • Thread starter Thread starter singha
  • Start date Start date
S

singha

Is it possible to programmatically force Excel to treat a column as
TEXT when opening a file? What I am getting at is able to double
click on a .txt file and by-passing the column conversion dialog in
Excel; is this possible?

thanks in advance,
singha
 
Hi Singha,
Not by the means that you asked, but you can record a macro
where you go through the dialog, beginning with opening the
file and then use that macro to open the file in the future.
 
Back
Top