cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar

Excel Import - specific column types or formats

It would be helpful to be able to identify column types (numeric, character) or column format when importing Excel files.  There can be some columns where you want to force them to character (i.e. serial numbers that begin with a 0) or a column which is a date time, and you want it to appear only as a date. These features are available for CSV files, but not Excel files, so it seems like something that could easily be applied.

1 Comment
nikles
Level VI

Hi.  I agree 100%.  I just posted a slightly-related, although not identical request.  Linking here for visibility:

https://community.jmp.com/t5/JMP-Wish-List/Force-Character-Column-Data-Type-for-Open-and-Multiple-Fi...