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?