When opening a text file containing security IDs(mixture of numbers and characters), any security ID containing a "E" in the 8th position, followed by numbers, is interpreted as scientific notation. This goes further than cell formatting, the cell data has been altered. I have tried pre-setting the cell format to text prior to getting the external data, but no luck. BTW: MS Word opens this file just fine.
Any ideas?
- Audri
Any ideas?
- Audri