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