cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Browse apps to extend the software in the new JMP Marketplace
%3CLINGO-SUB%20id%3D%22lingo-sub-802362%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3EComment%20exporter%20le%20format%20de%20l'heure%20d'Excel%20vers%20JMP%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-802362%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EBonjour%2C%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3CP%3EJ'ai%20le%20format%20de%20l'heure%2C%20mm-jj-aaaa%20hh%3Amm%3Ass%2C%20sur%20Excel.%3C%2FP%3E%3CP%3ESur%20JMP%2C%20seul%20le%20format%20mm-jj-aa%20est%20affich%C3%A9.%20J'ai%20modifi%C3%A9%20le%20format%20en%20mdy%20h%3Am%3As%20dans%20%C2%AB%26nbsp%3BInformations%20sur%20la%20colonne%26nbsp%3B%C2%BB.%3C%2FP%3E%3CP%3ESeul%20le%20format%20mm-jj-aa%20appara%C3%AEt%20toujours%20sur%20JMP.%3C%2FP%3E%3CP%3EQuelqu'un%20pourrait-il%20m'aider%20avec%20%C3%A7a%20s'il%20vous%20pla%C3%AEt%20%3F%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3CP%3EMerci%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-802362%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CLINGO-LABEL%3EFusion%20et%20nettoyage%20des%20donn%C3%A9es%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-802446%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%20%3A%20Comment%20exporter%20le%20format%20d'heure%20d'Excel%20vers%20JMP%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-802446%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EQuelle%20version%20de%20JMP%20utilisez-vous%20%3F%20Utilisez-vous%20l'assistant%20Excel%20pour%20charger%20les%20donn%C3%A9es%20dans%20JMP%20%3F%20Pouvez-vous%20partager%20un%20petit%20exemple%20de%20fichier%20Excel%20qui%20peut%20%C3%AAtre%20utilis%C3%A9%20pour%20reproduire%20le%20probl%C3%A8me%20%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-803051%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%20%3A%20Comment%20exporter%20le%20format%20d'heure%20d'Excel%20vers%20JMP%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-803051%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EOh%2C%20je%20ne%20voulais%20pas%20accepter%20comme%20solution%2C%20mais%20j'utilise%20JMP%20Pro%2017%3C%2FP%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar
joepark
Level III

How to export time format from Excel to JMP?

Hello,

 

I have time format, mm-dd-yyyy hh:mm:ss, on excel. 

On JMP, it only shows mm-dd-yy format. I changed the format to m-d-y h:m:s on 'column info'.

Still only mm-dd-yy appears on JMP.

Could someone please help me with this?

 

Thank you

2 REPLIES 2
jthi
Super User

Re: How to export time format from Excel to JMP?

Which JMP version are you using? Are you using excel wizard to load the data into JMP? Can you share a small example excel file which can be used to replicate the issue?

-Jarmo
joepark
Level III

Re: How to export time format from Excel to JMP?

Oh i did not meant to accept as a solution but I use JMP Pro 17