Stopping Excel from automatically converting CSV data to number format when opening CSV file.
I am opening a CSV file with Excel. I want excel to leave the data in certain fields alone and not convert it. Excel automatically converts the data value of "001" to the number "1". However, I need the sequence 001 to remain so I can concatenate it with another data value that has a similar sequence of 001 so that resulting data value is 001001 NOT 11. How do I prevent excel from autoconverting the data when it opens a csv file?
Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!