Leading "0" Zeros - Stop from removing

Copper Contributor

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

@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?

@Drewcipher 

To my knowledge there is no such option