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
Data Blending and CleanupRe: 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?
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