cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
The Discovery Summit 2025 Call for Content is open! Submit an abstract today to present at our premier analytics conference.
Choose Language Hide Translation Bar
View Original Published Thread

How to export time format from Excel to JMP?

joepark
Level III

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