Subscribe Bookmark RSS Feed

Exporting to Excel from JMP Categorical-Formatting

miller_jl_3

Community Trekker

Joined:

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

 

 

1 REPLY
Byron_JMP

Staff

Joined:

Apr 26, 2012

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

In your preferences do you have file locations specified?