My workflow is as follow:
Data scrap => convert to excel (A) => join excel (A) with excel (B)
I am facing an issue with converting the scraped data. Instead of showing a string of numbers for Column A [see row 2], my excel (A) showed this:
Column A Column B Column C
28699395 XXX 555
3.16E+08 YYY 666
This has resulted in unable to join my data in excel (B) as Column A is the common denominator.
Anybody here has the solution?