Excel paste function to column formatted as text


New Member
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?