I need to import an excel table to access. I have data that are product codes (all text). It´s the first column of my table. The numbers cells appeared as numbers and cells with letters appeared as text in my original excel table.
I decided to convert everything to text, with format cell "number" and "text" within excel. All cells appeared to be converted to text but some codes were written in cientific notation. I guess the digits product codes with more than 10 digits.
It seems so simple but I don´t konw how to keep it simply text! I tried to locate and replace but excel doesn´t locate the +E that I see on cells.
I send an example file (my file has more than 24.000 lines and I can´t make it one by one).
Please no programming on answers. I am just an (poor) ordinary excel user.
I am using office 2007