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
Decimal separator after CSV import
Luca Rivoira in Excel on
6 Replies
Import a CSV File and Pivot tables
gabriellerocha in Excel on
3 Replies
Excel Import 32 bit vs 64 bit
Brad Fretti in Excel on
1 Replies
reverse text to columns for .csv import
milly87 in Excel on
3 Replies