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.

@Sam_Taf,

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
Balamurugan.S

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.