I have data with serial numbers that are up to 20 digits in length. They are alpha numeric but sometimes only happen to have numbers. When that is the case Excel converts them to Exponential numerics as soon as it sees them. The only way I can restore the text version is to manually insert an apostrophe at the beginning. But since I import them by the thousands, this is not feasible. Is there a way to prevent this from happening?
Thanks.
Thanks.