CSV files

%3CLINGO-SUB%20id%3D%22lingo-sub-1539073%22%20slang%3D%22en-US%22%3ECSV%20files%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1539073%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20the%20last%203%20weeks%20CSV%20files%20downloaded%20for%20my%20bank%20account%20no%20longer%20have%20the%20same%20date%20format%20in%20the%20same%20column%20or%20when%20copy%20pasted%20to%20an%20excel%20sheet%20to%20be%20sorted%20etc%20maintain%20the%20same%20issues%20and%20I%20cannot%20change%20the%20date%20format%20no%20mater%20what%20I%20do%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1539073%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1539130%22%20slang%3D%22en-US%22%3ERe%3A%20CSV%20files%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1539130%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F736764%22%20target%3D%22_blank%22%3E%40Georges888%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EBetter%20to%20have%20bit%20more%20details%2C%20but%20you%20may%20try%20to%20convert%20to%20proper%20dates%20selecting%20the%20column%20with%20them%2C%20on%20ribbon%20Data-%26gt%3BText%20to%20Columns%20and%20on%20third%20step%20of%20the%20wizard%20select%20Date%20and%20MDY%20or%20which%20source%20format%20you%20have.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1539833%22%20slang%3D%22en-US%22%3ERe%3A%20CSV%20files%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1539833%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20Sergei%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETried%20that%20before%20and%20again%20now%20and%20what%20happens%20is%20that%20dates%20that%20read%2007-01-2020%20become%207-jan-2020%20however%20dates%20that%20are%20show%20as%206%2F30%2F20%20remain%20as%20is%20and%26nbsp%3B%20when%20I%20force%20a%20change%20by%20typing%20it%20in%20the%20cell%20it%20does%20the%20same%20and%20goes%20to%207-Jan-20.%26nbsp%3B%20When%20I%20select%20the%20column%20and%20format%20all%20cells%20to%20a%20format%20it%20does%20not%20take%2C%20no%20matter%20what%20I%20try%20and%20always%20on%20the%20CSV%20sheet.%20I%20then%20tried%20to%20capy%20and%20paste%20the%20values%20on%20a%20excel%20sheet%20column%20and%20nothing%20changes%20it%20seems%20to%20import%20the%20problem%20to%20wherever%20I%20paste.%26nbsp%3B%20Hope%20this%20helps%20expand%20on%20my%20problem.%20Also%20added%20and%20attachment%20with%20the%20issue%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1544605%22%20slang%3D%22en-US%22%3ERe%3A%20CSV%20files%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1544605%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F736764%22%20target%3D%22_blank%22%3E%40Georges888%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt%20converts%20nothing%2C%20you%20still%20have%20texts%20instead%20of%20dates%20as%20they%20are%20in%20the%20source%20file%20if%20open%20it%20Notepad%20or%20any%20other%20text%20editor%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20156px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F207713i49A86C607863F85A%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3ETo%20convert%20to%20dates%2C%20open%20csv%20in%20Excel%2C%20select%20first%20column%20with%20such%20texts%2C%20on%20ribbon%20Data-%26gt%3BText%20to%20Columns%2C%20select%20fixed%20width%20on%20first%20step%20and%20on%20third%20one%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20385px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F207714iDB43DA8B44A13EA1%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EFinish.%20Result%20is%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20324px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F207715iBC0B1024C3F1FED8%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EIn%20your%20case%20dates%20will%20be%20in%20your%20local%20format.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

In the last 3 weeks CSV files downloaded for my bank account no longer have the same date format in the same column or when copy pasted to an excel sheet to be sorted etc maintain the same issues and I cannot change the date format no mater what I do 

 

3 Replies

@Georges888 

Better to have bit more details, but you may try to convert to proper dates selecting the column with them, on ribbon Data->Text to Columns and on third step of the wizard select Date and MDY or which source format you have.

@Sergei Baklan 

 

Hi Sergei 

 

Tried that before and again now and what happens is that dates that read 07-01-2020 become 7-jan-2020 however dates that are show as 6/30/20 remain as is and  when I force a change by typing it in the cell it does the same and goes to 7-Jan-20.  When I select the column and format all cells to a format it does not take, no matter what I try and always on the CSV sheet. I then tried to capy and paste the values on a excel sheet column and nothing changes it seems to import the problem to wherever I paste.  Hope this helps expand on my problem. Also added and attachment with the issue

 

@Georges888 

It converts nothing, you still have texts instead of dates as they are in the source file if open it Notepad or any other text editor

image.png

To convert to dates, open csv in Excel, select first column with such texts, on ribbon Data->Text to Columns, select fixed width on first step and on third one

image.png

Finish. Result is

image.png

In your case dates will be in your local format.