Thank you for your reply but I am not importing text file. I am importing HTML tables to JMP. All data are characters. When converting to numerical data, I have the problem.
I think the two digit year rule only applies during the import. I don't think it is used for a later conversion of the column from character to numeric.
When I import the column is automatically assigned to numeric, date format.
The HTML was saved as characters.
Are you changing the format during import? I don't understand how you are importing a date as characters, JMP should import this as a numeric automatically.
Could you provide the actual HTML??? I just hand wrote one to check my answer before replying.