Excel paste function to column formatted as text

Leni

New Member
Hi,
In my rpa, I have a input excel file with columns formatted as text. I have to input functions to certain columns of this input excel. I am using Excel VBO's Copy and Paste Worksheet Range action for this. But when I paste the function, they are displayed as text and the function does not work. I even tried formatting cells to General before pasting. But that does not seem to work, because after the paste always the column format seems to change back to Text. Any idea how to fix this?
 
Top