I want to import a text file with some long numbers (16 characters and more).
Excel automatically converts them to floating point numbers which causes it
to lose some digits of precision. When I put quotes around the numbers excel
treats it as text but leaves the quotes around the number and removing the
quotes causes it to covert to floating point even if the format for the cell
is TEXT. If during the import I specify the columns as TEXT everything is
fine. However I need to do this for many files and many columns and I need
do the process many times on an on going basis. Is there anyway to automate
this?
--
Steve

If the layout of the data is always the same, then you could record a macro when
you do it once and rerun it for all the other files.

If you need help modifying the code, post back with your question and I bet
you'll get help.

Steve wrote:

I want to import a text file with some long numbers (16 characters and more).
Excel automatically converts them to floating point numbers which causes it
to lose some digits of precision. When I put quotes around the numbers excel
treats it as text but leaves the quotes around the number and removing the
quotes causes it to covert to floating point even if the format for the cell
is TEXT. If during the import I specify the columns as TEXT everything is
fine. However I need to do this for many files and many columns and I need
do the process many times on an on going basis. Is there anyway to automate
this?
--
Steve

--

Dave Peterson