https://community.jmp.com/t5/Discussions/Problem-to-transfer-continuous-data-from-excel-to-jmp/m-p/554398#M76907 <P>This was stuck in the spam filter over the weekend, don't know why.</P> <P>&nbsp;</P> <P>The last row of the xlsx has non-numeric data in many columns. JMP preserves the data from the spread sheet as character data; you might use recode to fix it.</P> <P>Other columns have units attached to the numbers; JMP keeps those as character data as well. If the units are consistent, you might use find/replace to remove them.</P> <P>Once the character data is cleaned up, the column can be converted from character to numeric.</P> <P>Other people here have much more experience with data cleaning and might have better suggestions.</P> Mon, 10 Oct 2022 13:52:12 GMT Craige_Hales 2022-10-10T13:52:12Z https://community.jmp.com/t5/Discussions/Problem-to-transfer-continuous-data-from-excel-to-jmp/m-p/553794#M76861 <P>Dear community experts,</P><P>&nbsp;</P><P>I try to import the dataset with continuous data (factor6, 7, 8, 9, 12, 13,15 and everything beyond fifteen are responses) from JMP to excel.&nbsp;</P><P>After export I cannot change the data type to continuous, its not available. I already changed everything to number formate and it didnt help.</P><P>Its irritating for me also, that all the responses are continuous, even they come from the same dataset. I am a bit frustrated here and every help is highly appreciated.</P><P>Thanks a lot</P> Sat, 10 Jun 2023 23:55:10 GMT https://community.jmp.com/t5/Discussions/Problem-to-transfer-continuous-data-from-excel-to-jmp/m-p/553794#M76861 SimonFuchs 2023-06-10T23:55:10Z https://community.jmp.com/t5/Discussions/Problem-to-transfer-continuous-data-from-excel-to-jmp/m-p/554398#M76907 <P>This was stuck in the spam filter over the weekend, don't know why.</P> <P>&nbsp;</P> <P>The last row of the xlsx has non-numeric data in many columns. JMP preserves the data from the spread sheet as character data; you might use recode to fix it.</P> <P>Other columns have units attached to the numbers; JMP keeps those as character data as well. If the units are consistent, you might use find/replace to remove them.</P> <P>Once the character data is cleaned up, the column can be converted from character to numeric.</P> <P>Other people here have much more experience with data cleaning and might have better suggestions.</P> Mon, 10 Oct 2022 13:52:12 GMT https://community.jmp.com/t5/Discussions/Problem-to-transfer-continuous-data-from-excel-to-jmp/m-p/554398#M76907 Craige_Hales 2022-10-10T13:52:12Z