Set excel data format

Hello,

i want to set 292221,90 to the following format 29 2221,90, in uipath

Hi @abdel

I have created an workflow according to your requirements please go through it an let me know if you have any doubts. SetString.zip (2.6 KB)

here is the result: 29 2221,90 , I’m expecting 292 221,90

i sthere any VB code that can do that

In fact the goal is if to have a column :

0,00
209617,40
19951979,89
338000,00
250000,00
699860,66
2215,30
1026342855,54
57375,00
292221,90
450000,00
280812545,48
1480566,10
-0,06
38299,87
253065,37
929939,01
55531222,44

then extract the following format:
209 617,40
19 951 979,89

etc