cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Aturu
New Member

Paste data table variables (decimals) as numbers, not text

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.

 

1 ACCEPTED SOLUTION

Accepted Solutions
Gidi
Resolver I
Resolver I

Best solution is currently to copy&paste the values via send keys action instead of using the Excel actions of Power Automate Desktop. 

View solution in original post

1 REPLY 1
Gidi
Resolver I
Resolver I

Best solution is currently to copy&paste the values via send keys action instead of using the Excel actions of Power Automate Desktop. 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,126)