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.