Input Number conversion and rounding off

[Abhii2658]

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. 

[JagdeeshN · Accepted solution]

Hi @Abhii2658 ,

Please find attached a sample workflow to convert both scenarios you have mentioned.

Hope this helps.

Best,

Jagdeesh

[Drussek · Accepted solution]

May it be as attached?