Forum Discussion
ARC_369
Feb 06, 2020Copper Contributor
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...
SergeiBaklan
Feb 07, 2020Diamond Contributor
Possible options are described here Stop Excel from Converting Text to Number or Date format when Opening a CSV file
- DrewcipherOct 19, 2020Copper Contributor
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?
- SergeiBaklanOct 19, 2020Diamond Contributor
To my knowledge there is no such option