Home

Maintaining date format in CSV

%3CLINGO-SUB%20id%3D%22lingo-sub-691432%22%20slang%3D%22en-US%22%3EMaintaining%20date%20format%20in%20CSV%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-691432%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20to%20save%20a%20CSV%20file%20with%20a%20specific%20date%20format%2C%20but%20every%20time%20I%20try%20to%20save%20the%20file%20it%20keeps%20saying%20it's%20not%20an%20acceptable%20format%2C%20and%20then%20changes%20it%20to%20another%20format.%20I%20have%20tried%20telling%20the%20spreadsheet%20to%20read%20as%20if%20it's%20text%2C%20but%20it%20keeps%20switching%20my%20format.%20How%20do%20I%20get%20excel%20to%20mind%20it's%20own%20business%20and%20accept%20my%20format%20as-is%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-691432%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-691472%22%20slang%3D%22en-US%22%3ERe%3A%20Maintaining%20date%20format%20in%20CSV%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-691472%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F360070%22%20target%3D%22_blank%22%3E%40etaylor94%3C%2FA%3E%26nbsp%3B-%3C%2FP%3E%3CP%3EDo%20you%20have%20a%20sample%20of%20your%20specific%20format%3F%3C%2FP%3E%3CP%3EIn%20a%20quick%20test%20I%20ran%2C%20leading%20Zero's%20are%20removed%3B%20I%20added%20a%20single%20quote%20(%20'%20)%20to%20convert%20the%20cell%20to%20Text%20but%20that%20just%20seems%20to%20work%20the%20same%20as%20using%20the%20Ribbon.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ein%20the%20cell...%20'06%2F13%2F2019%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Emm%2Fdd%2Fyyyy%20essentially.%3C%2FP%3E%3C%2FLINGO-BODY%3E
etaylor94
Occasional Visitor

I need to save a CSV file with a specific date format, but every time I try to save the file it keeps saying it's not an acceptable format, and then changes it to another format. I have tried telling the spreadsheet to read as if it's text, but it keeps switching my format. How do I get excel to mind it's own business and accept my format as-is?

1 Reply

@etaylor94 -

Do you have a sample of your specific format?

In a quick test I ran, leading Zero's are removed; I added a single quote ( ' ) to convert the cell to Text but that just seems to work the same as using the Ribbon.

 

in the cell... '06/13/2019

 

mm/dd/yyyy essentially.

Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
202 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies