If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Importing Long Numbers as Text cells
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 |
#2
|
|||
|
|||
Importing Long Numbers as Text cells
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 |
Thread Tools | |
Display Modes | |
|
|