Home

Quoting Date in Excel for CSV

%3CLINGO-SUB%20id%3D%22lingo-sub-698238%22%20slang%3D%22en-US%22%3EQuoting%20Date%20in%20Excel%20for%20CSV%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-698238%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20experiencing%20a%20challenge%20with%20how%20to%20configure%20a%20date%20field%20in%20Excel%20so%20when%20the%20file%20is%20saved%20as%20a%20csv%20the%20date%20field%20is%20enclosed%20in%20quotes.%26nbsp%3B%20I%20have%20tried%20the%20custom%20date%20format%20in%20Excel%2C%20Format%20%26gt%3B%20Cells%20%26gt%3B%20Custom%20setting%20this%20as%26nbsp%3B%5C%22m%2Fd%2Fyyyy%20hh%3Amm%5C%22%2C%20date%20is%20set%20to%26nbsp%3B%226%2F11%2F2019%2014%3A15%22%2C%20but%20when%20I%20save%20the%20files%20as%20a%20csv%20and%20view%20this%20in%20notepad%20the%20date%20is%20displayed%20like%20this%3A%26nbsp%3B%26nbsp%3B%2C%22%22%226%2F11%2F2019%2014%3A15%22%22%22%2C%20I%20know%20I%20can%20edit%20this%20with%20notepad%20and%20find%20and%20replace%20the%20quotes%20but%20I'm%20trying%20to%20avoid%20that%20extra%20step.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20in%20advance%20for%20assistance.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-698238%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
cfarrell
Occasional Visitor

I'm experiencing a challenge with how to configure a date field in Excel so when the file is saved as a csv the date field is enclosed in quotes.  I have tried the custom date format in Excel, Format > Cells > Custom setting this as \"m/d/yyyy hh:mm\", date is set to "6/11/2019 14:15", but when I save the files as a csv and view this in notepad the date is displayed like this:  ,"""6/11/2019 14:15""", I know I can edit this with notepad and find and replace the quotes but I'm trying to avoid that extra step.  

 

Thank you in advance for assistance.  

 

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies