Feb 06 2020 07:00 AM
Hello everyone, So i deal with a lot Part Numbers and Serial Numbers that begin with the number "0".
That being said, the software i use only allows to export this data in CVS format. But once i open the excel sheet, all the "0" are missing. How can i change the setting of Excel to always treat all cells as a Text so that i can keep all the data i need regardless if i export the data in any format.
I am not sure how to deal with this issue, Please help out. Thank you.
Feb 07 2020 01:17 PM
Possible options are described here Stop Excel from Converting Text to Number or Date format when Opening a CSV file
Oct 19 2020 06:10 AM
@Sergei Baklan I have found these solutions, but the problem is that the work application only offers the option to Export to Excel, which automatically launches Excel and sends the data into a newly generated sheet. I am not able to get a CSV file from the app. Is there a way to set Excel to create new sheets and not auto format the data?
Oct 19 2020 09:05 AM
To my knowledge there is no such option