thsndsep
Syntax:
Value
String
thsndsep
(
String
str)
Description:
Adds thousands separator to
str
.
Examples:
($a1:$a5) = thsndsep($self)
Before:
A
B
C
1
1
4
2
500
3
-3455600
32
4
apple
-7.2
5
0.00002
18
6
16
41
After:
A
B
C
1
01
4
2
500
3
-3,455,600
32
4
apple
-7.2
5
00.00002
18
6
16
41
($b1:$d10) = thsndsep($a)