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.
Microsoft ExcelMicrosoft Access
8/22/2022 - Mon
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!