Unable to change the column format after data scraping

Hello everyone,

I have a problem with a data scraping action.

with the data scraping i have a column of function and another column with salary with the mention "“k€”. For example project manager - 60 k€. I copy these informations in excel file and before i remove the string “k€”. But the column salary have a text format and i can’t change it in number format.

Could you help me?

Thank you

Hi @Sam_Taf,

Try reading the sheet with Read Range, and then in a For Each, use .Replace to remove the text.

I will make a workflow for you that you can use.

Thank you for your answer William.

I tried this solution yet but it doesn’t work.

I tried for each row of the datatable an assign with replace. I removed the string “k€” but when it paste in excel the column have a text format.


See the below workflow. This should do what you need. You may need to change the column data type in Excel once the process has run

Main.xaml (10.2 KB)

Edit: Removed previous replies so only one functional workflow is available.

Hi ,
Maybe this can help you.

Here is an activity called “Change cell type”

Video guide :\

Thank you

Thank you very very much. It works now.

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.