BookmarkSubscribeSubscribe to RSS Feed

Exporting to Excel from JMP Categorical-Formatting


Community Trekker


Aug 19, 2015

I have been so frustrated with this and hoping someone can help.  Is there a way to do these 2 things (or at least 1 of them) when exporting data from JMP Categorical to Excel


-  Auto format the %'s into %'s in excel, rather than a number  (because there are actually #'s in the table, it's not as easy to do a global change to %'s in my sheet)

-  Auto open Excel after exporting from JMP Categorical.  Currently, I have to save it and then go find it to open it


FYI, I'm using Excel 2013






Apr 26, 2012

Just to check, you're saving files from the Categorical platform?

In your preferences do you have file locations specified?



JMP Systems Engineer, Pharm and BioPharm Sciences