Hello !
I have sample numbers in col A that I want to format as B. Their data type is V_String
A | B | |
56.206,26 | 56,206 | |
264.085,84 | 264,086 | |
56.444,56 | 56,445 | |
222.680,00 | 222,680 | |
369.824,00 | 369,824 | |
4.524.456,00 | 4,524,456 | |
Type 2 | Type 2 | |
52188 | 52,188 | |
282.01 | 282 | |
2280 | 2,280 | |
80.1 | 80 | |
52.65 | 53 | |
115.83 | 116 | |
382.28 | 382 | |
88.28 | 88 | |
1206 | 1,206 | |
1050 | 1,050 | |
211 | 211 | |
23822 | 23,822 | |
5705220 | 5,705,220 |
Please advise.
Solved! Go to Solution.
Hi @Abhii2658 ,
Please find attached a sample workflow to convert both scenarios you have mentioned.
Hope this helps.
Best,
Jagdeesh