I have some data in CSV files that I need to import in to another program. Column A in the file contains the location of where the data in subsequent columns is mapped in the software. The locations in this software contain both numbers and letters, so I've formatted column A as TEXT. However, when I save the file, close it, and reopen the file, the formatting reverts to what Excel thinks I want. The cells in column A that I have difficulty with are cells that contain a leading zero or an E in it. For example:
084 - reverts to 84
085 - reverts to 85
065E1 - reverts to 65E1
TIA for any help!
084 - reverts to 84
085 - reverts to 85
065E1 - reverts to 65E1
TIA for any help!