https://community.jmp.com/t5/Discussions/Import-excel-in-JMP18/m-p/775181#M95721 <P>I don't think there are such settings. You might be able to change the format in the excel wizard</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jthi_0-1721844432693.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/66486iD6D814012A25DCE3/image-size/medium?v=v2&amp;px=400" role="button" title="jthi_0-1721844432693.png" alt="jthi_0-1721844432693.png" /></span></P> <P>or better option in my opinion, change the data and modeling type AFTER you have imported the data into JMP table.</P> <P>&nbsp;</P> <P>Edit: You can get information about the excel import from <A href="https://www.jmp.com/support/help/en/18.0/#page/jmp/preview-and-import-microsoft-excel-data.shtml#" target="_blank">https://www.jmp.com/support/help/en/18.0/#page/jmp/preview-and-import-microsoft-excel-data.shtml#</A> and there were changes in JMP18&nbsp;<A href="https://community.jmp.com/t5/JMP-Knowledge-Base/Changes-to-the-import-of-Microsoft-Excel-files-in-JMP-18/ta-p/655981" target="_blank">https://community.jmp.com/t5/JMP-Knowledge-Base/Changes-to-the-import-of-Microsoft-Excel-files-in-JMP-18/ta-p/655981</A>&nbsp;</P> Wed, 24 Jul 2024 18:14:30 GMT jthi 2024-07-24T18:14:30Z https://community.jmp.com/t5/Discussions/Import-excel-in-JMP18/m-p/775170#M95720 <P>Previously using JMP17, any import format of a column in excel would carry over the same format into JMP, but JMP18 is changing from numeric to character if there are any blank cells in that column.&nbsp; Is there a setting in preferences I need to change?</P> Wed, 24 Jul 2024 17:58:40 GMT https://community.jmp.com/t5/Discussions/Import-excel-in-JMP18/m-p/775170#M95720 hgarbig 2024-07-24T17:58:40Z https://community.jmp.com/t5/Discussions/Import-excel-in-JMP18/m-p/775181#M95721 <P>I don't think there are such settings. You might be able to change the format in the excel wizard</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jthi_0-1721844432693.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/66486iD6D814012A25DCE3/image-size/medium?v=v2&amp;px=400" role="button" title="jthi_0-1721844432693.png" alt="jthi_0-1721844432693.png" /></span></P> <P>or better option in my opinion, change the data and modeling type AFTER you have imported the data into JMP table.</P> <P>&nbsp;</P> <P>Edit: You can get information about the excel import from <A href="https://www.jmp.com/support/help/en/18.0/#page/jmp/preview-and-import-microsoft-excel-data.shtml#" target="_blank">https://www.jmp.com/support/help/en/18.0/#page/jmp/preview-and-import-microsoft-excel-data.shtml#</A> and there were changes in JMP18&nbsp;<A href="https://community.jmp.com/t5/JMP-Knowledge-Base/Changes-to-the-import-of-Microsoft-Excel-files-in-JMP-18/ta-p/655981" target="_blank">https://community.jmp.com/t5/JMP-Knowledge-Base/Changes-to-the-import-of-Microsoft-Excel-files-in-JMP-18/ta-p/655981</A>&nbsp;</P> Wed, 24 Jul 2024 18:14:30 GMT https://community.jmp.com/t5/Discussions/Import-excel-in-JMP18/m-p/775181#M95721 jthi 2024-07-24T18:14:30Z