Round Off number even if data type is string

[KamenRider]

Hi

I have some inquiry here whose data type is string. The conditions is to round off number to 5 decimal places. However if the content is "Price", it should be retain as is and if it is null then as is also. Below is an example.

 

I would like results to look like this.

 

Hope to hear from anyone.

Kamen

[SPetrie · Accepted solution]

Try this formula if REGEX_Match([Price],".*\d.*") then tostring(round(ToNumber([Price]),0.00001),5) else [Price] endif

[grazitti_sapna · Accepted solution]

Hi @KamenRider 
I have made workflow for your use case.
Hope it works for you
Thanks

[KamenRider]

Thank you so much. Your formula works.

Kamen