JavaScript required
We’re sorry, but Coda doesn’t work properly without JavaScript enabled.
Skip to content
Gallery
SubstituteAll
EU numbers into USA format
Problematic SubstituteAll
RegexReplace
More
Share
Explore
EU numbers into USA format
Examples and practical applications
The blog explaining these details: ⤵️
T
he simple solution
thisRow.theNumber.SubstituteAll(".","").Substitute(",",".")
Name
theNumber
substitute
substituteAll
solution
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 (
Ctrl
P
) instead.