I am having difficulty with number formatting in Excel.
The attached file contain a sample download (total list is 300,000 records) from our Cognos reporting system (column A). The data in these cells are formatted as numbers in Excel. However, if I import to Access, they are classified as text. In addition, performing calculations on these cells yields erroneous results (see columns B & C).
I did find that if you simply F2 in each cell in column A (replicated in column F), Excel recognizing them as values; calculations work fine and I can import into Access as values.
How can I replicate the F2 keystoke 300,000 times with or without VBA? And why does Excel do this with certain downloaded data?
Thanks in advance.