Hi,

I'm importing an excel spreadsheet (downloaded/refreshed from Datastream, the data provider) but it turns out that some cells are randomly imported in date format instead of general numbers. I cannot do anything from Excel, I need to solve the problem from Stata. Here is an exemple:

Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input str24 NAME str8 DATATYPE str17 _12_31_2020 str18 _9_30_2020 str17 _6_30_2020 str18 _3_31_2020 str31 _12_31_2019
"UNITED AIRLINES HOLDINGS" "WC01051A" "1993000" "  3/4/6275" "10/25/5223" "   3548084" "   4144084"
end
Here is the code I use to import. I have to import in string format for other reasons. Any idea on how to solve this problem?
Code:
import excel "0.main_data-${universe}.xlsx", clear sheet("Data_Query")  cellrange(A7) allstring