CSV format, starting with 0

Question

After saving in CSV format, numbers starting with 0 and 0 are removed. So how can you keep the length of the text inside the cell, it must be 7 bits, and the 0 at the beginning cannot disappear.

Answer 1

Hi,

As far as I know, this feature is not available in csv file format.

I suggest you refer to this support article and try the method:

https://www.iqaccountingsolutions.com/blog/dealing-with-leading-zeros-when-opening-a-csv-file-in-excel/#:~:text=Dealing%20With%20Leading%20Zeros%20When%20Opening%20a%20CSV,for%20known%20file%20types%20.%205%20Click%20OK

---

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.