I have JMP 16. Please enable Paste Special (Ctrl-Alt-V hot key) options in JMP, similarly to Excel. The latter has a very rich dialog window reproduced below. Include check box Do not change data type of receiving columns and convert incompatible data type entries to ‘missing values’ ( • ). This check box will act similarly to changing column properties in JMP: if there are non-numerical entries in some rows of columns the user wants to make Continuous, they will become missing values.