I am creating a large file in Excel that contains two columns with large numbers. I am formatting these columns (actually the entire worksheet) as TEXT.
When I save the file as .xlsx and open it back up, these columns still appear as text, which is good.
When I save the file as .csv and then open the file in a text editor, the columns appear as text, which is also good.
However, when I open the .csv file in Excel, these columns now appear in scientific format. I can manually reformat the columns, but that will not work for my purposes.
Is there any way for me to accomplish what I need? Specifically, I need to be able to create a .csv file that will display these long numbers (barcode values) as text, regardless of whether the file is opened in a text editor or Excel.
