Forum Discussion
Leading "0" Zeros - Stop from removing
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.
3 Replies
Possible options are described here Stop Excel from Converting Text to Number or Date format when Opening a CSV file
SergeiBaklan 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?
To my knowledge there is no such option
