https://community.jmp.com/t5/Discussions/TRUE-FALSE-data-from-Excel-importing-as-1-0/m-p/344376#M59408 <P>After recently upgrading to JMP15, all of my TRUE/FALSE data columns are importing from Excel as Numerical 1/0 instead of text. I have searched and can't find a preference or setting for this. How do I make sure the columns import as TRUE/FALSE? This didn't happen in JMP14.</P> Sat, 10 Jun 2023 23:24:16 GMT geneticjunkie 2023-06-10T23:24:16Z https://community.jmp.com/t5/Discussions/TRUE-FALSE-data-from-Excel-importing-as-1-0/m-p/344376#M59408 <P>After recently upgrading to JMP15, all of my TRUE/FALSE data columns are importing from Excel as Numerical 1/0 instead of text. I have searched and can't find a preference or setting for this. How do I make sure the columns import as TRUE/FALSE? This didn't happen in JMP14.</P> Sat, 10 Jun 2023 23:24:16 GMT https://community.jmp.com/t5/Discussions/TRUE-FALSE-data-from-Excel-importing-as-1-0/m-p/344376#M59408 geneticjunkie 2023-06-10T23:24:16Z https://community.jmp.com/t5/Discussions/TRUE-FALSE-data-from-Excel-importing-as-1-0/m-p/344396#M59409 <P>I noticed when opening an Excel file with the JMP Excel add-in, Boolean values get imported as numeric, but if opening the Excel file through the Excel Import Wizard or copy/paste from Excel to JMP, the Boolean values become text. Converting the numeric values to text is straightforward enough through Recode column utility or using a formula.<BR /><BR /></P> <PRE><CODE class=" language-jsl">Ex. dt &lt;&lt; New Column( "Boolean Text", Formula( if( :flag == 1, "TRUE", "FALSE" ) ) );</CODE></PRE> Sun, 03 Jan 2021 22:07:30 GMT https://community.jmp.com/t5/Discussions/TRUE-FALSE-data-from-Excel-importing-as-1-0/m-p/344396#M59409 Mark_Zwald 2021-01-03T22:07:30Z