This question already has an answer here:

In one of my cells I have the number 00780. I formatted it as text so it would not change to 780. I need to save the file as a CSV but every time I reopen the file it changes the formatting of the cells to general.

How to do I stop Excel from reformatting when reopening the file?

marked as duplicate by fixer1234, n8te, bertieb, phuclv, Pimp Juice IT Jul 17 '18 at 19:49

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

Browse other questions tagged or ask your own question.