CODEWITHSUNDEEP
excelworkfusion
Thisara Watawana
Thisara Watawana

Reputation: 344

Numerical Excel Value List in WorkFusion RPA Express

I’m currently in the process of developing a workflow in WorkFusion RPA Express. I’m trying to copy list of numbers from an excel sheet to the clipboard and paste it in another excel sheet. The values copied are integers however when it’s pasted to the other sheet it pasted with the decimal point. How can I paste this as a string or as an integer?

1st image with the integer

The pasted values from the clipboard

Upvotes: 0

Views: 611

Answers (2)

Alesia
Alesia

Reputation: 36

You can use the Number Format action (inside Variables group of actions) to reformat the value you paste in Excel.

Upvotes: 2

Samuel Hulla
Samuel Hulla

Reputation: 7099

A bit of googling would have gone a long way here..

Select the cell(s) where you paste the data and adjust the number of decimals with these buttons. This will also automatically change the format from General/Text to Number

enter image description here

Upvotes: 0

Related Questions