Excel Reader does not recognize number (double)

I have a problem importing data with the Excel Reader.

If I want to change the type on the “Transformation” sheet from a string to a number (double), the import process aborts.

If I leave all the data as a string, the data is read in, but incorrectly. For example, in the Excel file the number is given as normal, but in KNIME (by formatting it as a string) it is suddenly returned as “3.709162241E7”.

How can I solve this?

A solution that I already save the number in Excel as a number and not as a standard does not change anything. It is not recognized as a number by KNIME.

In advance: Thanks a lot for your help!