Scraping data and writing in excel

Im scraping data from a certain site. But when writing to excel the format for my scraped data is changed from numbers to general. How can it preserve the format

Hi @Tapiwa,
Have you tried to prepare “template” of excel spreadsheet with cells set to numbers and write data to that prepared file?

You could use a vba script to reformat the columns after writing. I’ve attached an example.

It requires using tha application scope and the invoke vba activity. (34.6 KB)