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