How to format numbers into currency format on MAKE

Questions & Answers
1

Hey, I have an input data that comes in the form of unformatted numbers like this

15000
1000

I want to format these numbers as the US currency formatting system with the right commas, so basically I want the output like this

15,000
1,000

How can I do this? I thought of using the format-number function but couldn’t figure it out and didn’t find an article on how to do it properly anywhere

1 Like
2

Formatnumber() will do the job.

formatNumber(1500; 2 ; . ; , )

2 Likes
3

Completely Tangentially: :rofl:

Do you know of a minimal/clean solution,

for alternative separator formatting, such as (lakhs/croresIndian Number System)

Comma after first 3 digits, then after every 2 repeating.

Example Inside
0  1 , 0  1 , 0 0, 0 0 0
 C   M   L  T
 R   I   A  H
 O   L   K  O
 R   L   H  U
 E   I  S
 O  A
 N  N
D
1 Like