In my process I OCR a value from a PDF, trim whitespaces and then write that value via set cell into an Excel.
Problem is that in the resulting Excel this value includes some hidden leading character. That character makes it impossible to convert that value into number format.
If I write the same value into the same excel file via enter keystrokes-variable I can convert it perfectly into a number (via multiplication with 1)
So it seems like the set cell value operation adds some hidden character in front of the value.
Is that a known error?