Skip to content

icon picker
EU numbers into USA format

Examples and practical applications
The blog explaining these details: ⤵️


The simple solution
thisRow.theNumber.SubstituteAll(".","").Substitute(",",".")
Name
theNumber
substitute
substituteAll
solution
1
Number 1
1.000.000.000,00
1000.000.000,00
1000000000,00
1,000,000,000
2
Number 2
234.567.890,12
234567.890,12
234567890,12
234,567,890.12
3
Number 3
876.543.210,34
876543.210,34
876543210,34
876,543,210.34
4
Number 4
456.789.123,45
456789.123,45
456789123,45
456,789,123.45
5
Number 5
123.456.789,56
123456.789,56
123456789,56
123,456,789.56
6
Number 6
987.654.321,67
987654.321,67
987654321,67
987,654,321.67
7
Number 7
654.321.987,78
654321.987,78
654321987,78
654,321,987.78
8
Number 8
321.987.654,89
321987.654,89
321987654,89
321,987,654.89
9
Number 9
789.123.456,90
789123.456,90
789123456,90
789,123,456.9
10
Number 10
567.890.123,01
567890.123,01
567890123,01
567,890,123.01
11
Number 11
345.678.912,23
345678.912,23
345678912,23
345,678,912.23
12
Number 12
912.345.678,34
912345.678,34
912345678,34
912,345,678.34
13
Number 13
678.912.345,45
678912.345,45
678912345,45
678,912,345.45
14
Number 14
432.109.876,56
432109.876,56
432109876,56
432,109,876.56
15
Number 15
210.987.654,67
210987.654,67
210987654,67
210,987,654.67
16
Number 16
109.876.543,78
109876.543,78
109876543,78
109,876,543.78
17
Number 17
543.210.987,89
543210.987,89
543210987,89
543,210,987.89
18
Number 18
768.543.210,90
768543.210,90
768543210,90
768,543,210.9
19
Number 19
890.123.456,01
890123.456,01
890123456,01
890,123,456.01
20
Number 20
102.345.678,12
102345.678,12
102345678,12
102,345,678.12
There are no rows in this table

Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.