How to remove csv file formatting when working with python?

Question

Python

I work with csv files through a python script, when writing to a file, let's say the number 9.4, it automatically enters 04/09/2021 into the cell, and if we try to remove the format manually, we will get 44295 at the output. How can I either disable formatting when writing, or manually restore these 9.4?

Answer 1

CSV is a text format.
The date is inserted by Excel with which you open it.