I seem to be having some issues with saving CSV files and then reopening them. Can someone or many of you help out?
I have file I saved as text. Some of the data has leading 0's that need to be stored as a csv file. I change the format to text the first time I create the file and save it as a csv, it uploads through our system fine. When I open the file to make adjustments it removes all of the leading 0's and changes the format to a number.
Is there something I am missing some place? I thought when I change the format it stays.