Numerical Excel Value List in WorkFusion RPA Express

Question

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?

Answer 1

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

Answer 2

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