topic Re: How to export time format from Excel to JMP? in Discussions

How to export time format from Excel to JMP?

joepark — Fri, 27 Sep 2024 19:21:45 GMT

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

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

jthi — Sat, 28 Sep 2024 05:08:06 GMT

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?

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

joepark — Tue, 01 Oct 2024 19:21:28 GMT

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