Help changing: DD-MM-YYYY HH:MM to YYYY-MM-DD HH:MM

%3CLINGO-SUB%20id%3D%22lingo-sub-3183513%22%20slang%3D%22en-US%22%3EHelp%20changing%3A%20DD-MM-YYYY%20HH%3AMM%20to%20YYYY-MM-DD%20HH%3AMM%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3183513%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20struggling%20with%20changing%20date%20formate%20in%20Excel%20form%26nbsp%3BDD-MM-YYYY%20HH%3AMM%20to%20YYYY-MM-DD%20HH%3AMM%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20tired%20to%20custom%20change%20with%20formate%20but%20it%20does%20not%20work.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20looked%20online%20and%20found%20few%20function%20like%20Isnumber%20or%20Iftext%20but%20it%20never%20worked.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20your%20help%20please%20as%20I%20am%20trying%20to%20export%20my%20excel%20data%20to%20WEKA%20which%20only%20recognize%20this%20formate%26nbsp%3BYYYY-MM-DD%20HH%3AMM%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20is%20also%20another%20problem.%20Even%20if%20I%20right%20the%20date%20I%20want%20from%20scratch%20the%20cell%20value%20at%20the%20top%20bar%20shows%20seconds%20and%20AM%2FPM.%20Changing%20cell%20formate%20does%20not%20change%20anything.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20very%20much%20in%20advance!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Sam99615_0-1645182785548.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F349456iE39FF3FB2B957A59%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Sam99615_0-1645182785548.png%22%20alt%3D%22Sam99615_0-1645182785548.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3183513%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3183881%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20changing%3A%20DD-MM-YYYY%20HH%3AMM%20to%20YYYY-MM-DD%20HH%3AMM%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3183881%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1311281%22%20target%3D%22_blank%22%3E%40Sam99615%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20formula%20bar%20always%20shows%20the%20date%20and%20time%20according%20to%20your%20computer's%20system%20settings.%3C%2FP%3E%0A%3CP%3EThe%20values%20in%20column%20A%20look%20like%20text%20values.%20Try%20this%20in%20B2%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DMID(A2%2C7%2C4)%26amp%3B%22-%22%26amp%3BMID(A2%2C4%2C2)%26amp%3B%22-%22%26amp%3BLEFT(A2%2C2)%26amp%3BMID(A2%2C11%2C6)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFill%20down.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi,

 

I am struggling with changing date formate in Excel form DD-MM-YYYY HH:MM to YYYY-MM-DD HH:MM 

 

I have tired to custom change with formate but it does not work.

 

I looked online and found few function like Isnumber or Iftext but it never worked. 

 

I need your help please as I am trying to export my excel data to WEKA which only recognize this formate YYYY-MM-DD HH:MM

 

There is also another problem. Even if I right the date I want from scratch the cell value at the top bar shows seconds and AM/PM. Changing cell formate does not change anything.

 

Thank you very much in advance!

 

Sam99615_0-1645182785548.png

 

1 Reply

@Sam99615 

The formula bar always shows the date and time according to your computer's system settings.

The values in column A look like text values. Try this in B2:

 

=MID(A2,7,4)&"-"&MID(A2,4,2)&"-"&LEFT(A2,2)&MID(A2,11,6)

 

Fill down.