In Google Sheets when you import the CSV just make sure to choose "Yes" to

Convert text to numbers, dates, and formulas