Transformed Data Incorrectly Saved in .csv Format

%3CLINGO-SUB%20id%3D%22lingo-sub-1496679%22%20slang%3D%22en-US%22%3ETransformed%20Data%20Incorrectly%20Saved%20in%20.csv%20Format%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1496679%22%20slang%3D%22en-US%22%3E%3CP%3EI%20use%20Office%202016%20and%20am%20training%20a%20new%20employee%20who%20has%20been%20given%20Office%20365.%26nbsp%3B%20I%20can%20import%20a%20.csv%20file%20step-by-step%2C%20which%20allows%20me%20to%20transform%20large%20numbers%20from%20scientific%20notation%20into%20text%20and%20save%20them%20in%20a%20new%20.csv%20file%20as%20text.%26nbsp%3B%20When%20my%20new%20employee%20uses%20the%20Office%20365%20import%2Ftransform%20feature%2C%20the%20large%20numbers%20are%20transformed%20to%20text%2C%20but%20when%20he%20saves%20that%20transformed%20spreadsheet%20using%20%22save%20as%22%20and%20selecting%20the%20%22Comma%20delimited%20(.csv)%22%20option%2C%20the%20text%20reverts%20back%20to%20scientific%20notation.%26nbsp%3B%20How%20can%20he%20force%20it%20to%20save%20the%20transformed%20data%20as%20text%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1496679%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I use Office 2016 and am training a new employee who has been given Office 365.  I can import a .csv file step-by-step, which allows me to transform large numbers from scientific notation into text and save them in a new .csv file as text.  When my new employee uses the Office 365 import/transform feature, the large numbers are transformed to text, but when he saves that transformed spreadsheet using "save as" and selecting the "Comma delimited (.csv)" option, the text reverts back to scientific notation.  How can he force it to save the transformed data as text?

0 Replies