Leading "0" Zeros - Stop from removing

%3CLINGO-SUB%20id%3D%22lingo-sub-1155766%22%20slang%3D%22en-US%22%3ELeading%20%220%22%20Zeros%20-%20Stop%20from%20removing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1155766%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20everyone%2C%20So%20i%20deal%20with%20a%20lot%20Part%20Numbers%20and%20Serial%20Numbers%20that%20begin%20with%20the%20number%20%220%22.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThat%20being%20said%2C%20the%20software%20i%20use%20only%20allows%20to%20export%20this%20data%20in%20CVS%20format.%20But%20once%20i%20open%20the%20excel%20sheet%2C%20all%20the%20%220%22%20are%20missing.%20How%20can%20i%20change%20the%20setting%20of%20Excel%20to%20always%20treat%20all%20cells%20as%20a%20Text%20so%20that%20i%20can%20keep%20all%20the%20data%20i%20need%20regardless%20if%20i%20export%20the%20data%20in%20any%20format.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20not%20sure%20how%20to%20deal%20with%20this%20issue%2C%20Please%20help%20out.%20Thank%20you.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1155766%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1160596%22%20slang%3D%22en-US%22%3ERe%3A%20Leading%20%220%22%20Zeros%20-%20Stop%20from%20removing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1160596%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F547498%22%20target%3D%22_blank%22%3E%40ARC_369%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPossible%20options%20are%20described%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.winhelponline.com%2Fblog%2Fstop-excel-convert-text-to-number-date-format-csv-file%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EStop%20Excel%20from%20Converting%20Text%20to%20Number%20or%20Date%20format%20when%20Opening%20a%20CSV%20file%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1795410%22%20slang%3D%22en-US%22%3ERe%3A%20Leading%20%220%22%20Zeros%20-%20Stop%20from%20removing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1795410%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3BI%20have%20found%20these%20solutions%2C%20but%20the%20problem%20is%20that%20the%20work%20application%20only%20offers%20the%20option%20to%20Export%20to%20Excel%2C%20which%20automatically%20launches%20Excel%20and%20sends%20the%20data%20into%20a%20newly%20generated%20sheet.%20I%20am%20not%20able%20to%20get%20a%20CSV%20file%20from%20the%20app.%20Is%20there%20a%20way%20to%20set%20Excel%20to%20create%20new%20sheets%20and%20not%20auto%20format%20the%20data%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1796157%22%20slang%3D%22en-US%22%3ERe%3A%20Leading%20%220%22%20Zeros%20-%20Stop%20from%20removing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1796157%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F837705%22%20target%3D%22_blank%22%3E%40Drewcipher%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETo%20my%20knowledge%20there%20is%20no%20such%20option%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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