Importing Long Numbers as Text cells

S

Steve

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?
 
D

Dave Peterson

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.
 

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

Changing Text To Numbers ? 1
long numbers colapse 2
Importing long numbers from CSV file 4
Importing CSV file (saved as Text) into XL as Text -- over 60 colu 1
Swap . and , when importing to Excel 2007 5
"formula is too long" AND test for whether double-quotes are next-to text or number?? 2
Disable conversion from text to number from .csv file 2
importing numbers as text 5

Top