Reading data from Excel file with cells having formula

Question

I am reading an Excel file and cell has formulas in it. Cell is formatted as percentage.

Alteryx is reading it as vString because cell contains alphanumeric values. I can not replicate excel formula in alteryx and have to read it from calculated cell. Below one example of the calculation and instead of doing the calculation myself (because a lot of other formulas are being applied before getting to this stage) I am reading last column.

V1V2V3V1/(V2/V3)0.124121610000.101973684210526

I want to read this as 0.101 (last column) but not unable to do so. Below snapshot of problem values being read by Alteryx especially one with very long decimal places.

caltang · Accepted Answer

Use the Multi-field formula to convert that field to a number (Double datatype), and it will read as a number and not a string. It will then be possible to do your mathematical operations thereafter.