I am trying to copy rows with values into another Excel sheet.
The rows contain numbers (some with a "," and some without because of the decimals).
To do this, I save each row to be copied in a variable as a data table and paste it into the other Excel sheet. The problem with this is that it defines all decimal numbers as text, and I don't want to convert each cell to a number individually or column by column.
How can I make it insert the variable only as numbers or recognize decimals as such? The function to read from an excel only contains the opportunity to read as text, or automated for the best match, not numbers.
Solved! Go to Solution.
Best solution is currently to copy&paste the values via send keys action instead of using the Excel actions of Power Automate Desktop.
Best solution is currently to copy&paste the values via send keys action instead of using the Excel actions of Power Automate Desktop.