cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • JMP will suspend normal business operations for our Winter Holiday beginning on Wednesday, Dec. 24, 2025, at 5:00 p.m. ET (2:00 p.m. ET for JMP Accounts Receivable).
    Regular business hours will resume at 9:00 a.m. EST on Friday, Jan. 2, 2026.
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.

Discussions

Solve problems, and share tips and tricks with other JMP users.
%3CLINGO-SUB%20id%3D%22lingo-sub-344376%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3EExcel%20%E3%81%8B%E3%82%89%201%2F0%20%E3%81%A8%E3%81%97%E3%81%A6%E3%82%A4%E3%83%B3%E3%83%9D%E3%83%BC%E3%83%88%E3%81%95%E3%82%8C%E3%82%8B%20TRUE%2FFALSE%20%E3%83%87%E3%83%BC%E3%82%BF%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-344376%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%3CP%3E%E6%9C%80%E8%BF%91%20JMP15%20%E3%81%AB%E3%82%A2%E3%83%83%E3%83%97%E3%82%B0%E3%83%AC%E3%83%BC%E3%83%89%E3%81%97%E3%81%9F%E5%BE%8C%E3%80%81%E3%81%99%E3%81%B9%E3%81%A6%E3%81%AE%20TRUE%2FFALSE%20%E3%83%87%E3%83%BC%E3%82%BF%E5%88%97%E3%81%8C%20Excel%20%E3%81%8B%E3%82%89%E3%83%86%E3%82%AD%E3%82%B9%E3%83%88%E3%81%A7%E3%81%AF%E3%81%AA%E3%81%8F%E6%95%B0%E5%80%A4%201%2F0%20%E3%81%A8%E3%81%97%E3%81%A6%E3%82%A4%E3%83%B3%E3%83%9D%E3%83%BC%E3%83%88%E3%81%95%E3%82%8C%E3%81%BE%E3%81%99%E3%80%82%E6%A4%9C%E7%B4%A2%E3%81%97%E3%81%BE%E3%81%97%E3%81%9F%E3%81%8C%E3%80%81%E3%81%93%E3%82%8C%E3%81%AB%E9%96%A2%E3%81%99%E3%82%8B%E8%A8%AD%E5%AE%9A%E3%82%84%E7%92%B0%E5%A2%83%E8%A8%AD%E5%AE%9A%E3%81%8C%E8%A6%8B%E3%81%A4%E3%81%8B%E3%82%8A%E3%81%BE%E3%81%9B%E3%82%93%E3%80%82%E5%88%97%E3%81%8C%20TRUE%2FFALSE%20%E3%81%A8%E3%81%97%E3%81%A6%E3%82%A4%E3%83%B3%E3%83%9D%E3%83%BC%E3%83%88%E3%81%95%E3%82%8C%E3%82%8B%E3%82%88%E3%81%86%E3%81%AB%E3%81%99%E3%82%8B%E3%81%AB%E3%81%AF%E3%81%A9%E3%81%86%E3%81%99%E3%82%8C%E3%81%B0%E3%82%88%E3%81%84%E3%81%A7%E3%81%99%E3%81%8B%3F%20%E3%81%93%E3%82%8C%E3%81%AF%20JMP14%20%E3%81%A7%E3%81%AF%E7%99%BA%E7%94%9F%E3%81%97%E3%81%BE%E3%81%9B%E3%82%93%E3%81%A7%E3%81%97%E3%81%9F%E3%80%82%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-344376%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%3CLINGO-LABEL%3E%E3%83%87%E3%83%BC%E3%82%BF%E3%82%A2%E3%82%AF%E3%82%BB%E3%82%B9%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3E%E5%A4%A7%E9%87%8F%E3%82%AB%E3%82%B9%E3%82%BF%E3%83%9E%E3%82%A4%E3%82%BA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-344396%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%EF%BC%9A1%2F0%E3%81%A8%E3%81%97%E3%81%A6%E3%82%A4%E3%83%B3%E3%83%9D%E3%83%BC%E3%83%88%E3%81%99%E3%82%8BExcel%E3%81%8B%E3%82%89%E3%81%AETRUE%20%2F%20FALSE%E3%83%87%E3%83%BC%E3%82%BF%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-344396%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EJMP%20Excel%E3%82%A2%E3%83%89%E3%82%A4%E3%83%B3%E3%82%92%E4%BD%BF%E7%94%A8%E3%81%97%E3%81%A6Excel%E3%83%95%E3%82%A1%E3%82%A4%E3%83%AB%E3%82%92%E9%96%8B%E3%81%8F%E3%81%A8%E3%80%81%E3%83%96%E3%83%BC%E3%83%AB%E5%80%A4%E3%81%8C%E6%95%B0%E5%80%A4%E3%81%A8%E3%81%97%E3%81%A6%E3%82%A4%E3%83%B3%E3%83%9D%E3%83%BC%E3%83%88%E3%81%95%E3%82%8C%E3%82%8B%E3%81%93%E3%81%A8%E3%81%AB%E6%B0%97%E4%BB%98%E3%81%8D%E3%81%BE%E3%81%97%E3%81%9F%E3%81%8C%E3%80%81Excel%E3%82%A4%E3%83%B3%E3%83%9D%E3%83%BC%E3%83%88%E3%82%A6%E3%82%A3%E3%82%B6%E3%83%BC%E3%83%89%E3%82%92%E4%BD%BF%E7%94%A8%E3%81%97%E3%81%A6Excel%E3%83%95%E3%82%A1%E3%82%A4%E3%83%AB%E3%82%92%E9%96%8B%E3%81%8F%E3%81%8B%E3%80%81Excel%E3%81%8B%E3%82%89JMP%E3%81%AB%E3%82%B3%E3%83%94%E3%83%BC%E3%81%97%E3%81%A6%E8%B2%BC%E3%82%8A%E4%BB%98%E3%81%91%E3%82%8B%E3%81%A8%E3%80%81%E3%83%96%E3%83%BC%E3%83%AB%E5%80%A4%E3%81%8C%E3%83%86%E3%82%AD%E3%82%B9%E3%83%88%E3%81%AB%E3%81%AA%E3%82%8A%E3%81%BE%E3%81%99%E3%80%82%20%E6%95%B0%E5%80%A4%E3%82%92%E3%83%86%E3%82%AD%E3%82%B9%E3%83%88%E3%81%AB%E5%A4%89%E6%8F%9B%E3%81%99%E3%82%8B%E3%81%93%E3%81%A8%E3%81%AF%E3%80%81%E5%88%97%E3%81%AE%E5%86%8D%E3%82%B3%E3%83%BC%E3%83%89%E5%8C%96%E3%83%A6%E3%83%BC%E3%83%86%E3%82%A3%E3%83%AA%E3%83%86%E3%82%A3%E3%81%BE%E3%81%9F%E3%81%AF%E6%95%B0%E5%BC%8F%E3%82%92%E4%BD%BF%E7%94%A8%E3%81%99%E3%82%8B%E3%81%93%E3%81%A8%E3%81%A7%E5%8D%81%E5%88%86%E3%81%AB%E7%B0%A1%E5%8D%98%E3%81%A7%E3%81%99%E3%80%82%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3EEx.%20dt%20%26lt%3B%26lt%3B%20New%20Column(%20%22Boolean%20Text%22%2C%20Formula(%20if(%20%3Aflag%20%3D%3D%201%2C%20%22TRUE%22%2C%20%22FALSE%22%20)%20)%20)%3B%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar

TRUE/FALSE data from Excel importing as 1/0

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.

1 REPLY 1

Re: TRUE/FALSE data from Excel importing as 1/0

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.

Ex. dt << New Column( "Boolean Text", Formula( if( :flag == 1, "TRUE", "FALSE" ) ) );

Recommended Articles