- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 12, 2023 06:25 AM
Hi.
Thank you in advance, I am wondering if there is a way to show numbers with thousand/comma separator if you combine it with a text in a formula field using concatenate. My Amount field is in currency format.
Current Formula:
Much appreciated.
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 12, 2023 10:42 PM - edited ‎Oct 13, 2023 12:17 AM
Hi @jot ,
I've developed an inexplicable formula.
REGEX_REPLACE(
REGEX_REPLACE(
REGEX_REPLACE(
REGEX_REPLACE(
REGEX_REPLACE(
REGEX_REPLACE(ROUND({Amount})&"", "(\\d{3})$", ",$1"),
"(\\d*)(\\d{3}),",
"$1,$2,"
),
"(\\d{1,3})(\\d{3}),",
",$1,$2,"
),
"(\\d{1,3}),(\\d{3}),",
"$1,$2,"
),
"^(\\d{1,3})(\\d{3}),",
"$1,$2,"
),
"^,",
""
) & " " & {asking-currency}

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 12, 2023 10:42 PM - edited ‎Oct 13, 2023 12:17 AM
Hi @jot ,
I've developed an inexplicable formula.
REGEX_REPLACE(
REGEX_REPLACE(
REGEX_REPLACE(
REGEX_REPLACE(
REGEX_REPLACE(
REGEX_REPLACE(ROUND({Amount})&"", "(\\d{3})$", ",$1"),
"(\\d*)(\\d{3}),",
"$1,$2,"
),
"(\\d{1,3})(\\d{3}),",
",$1,$2,"
),
"(\\d{1,3}),(\\d{3}),",
"$1,$2,"
),
"^(\\d{1,3})(\\d{3}),",
"$1,$2,"
),
"^,",
""
) & " " & {asking-currency}
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 18, 2023 03:27 PM
Thank you very much!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 27, 2024 10:15 AM
Is there anyway to have this formula work with decimals?
I am working on a project where this formula would be incredibly helpful, but I need to be able populate up to 2 decimal places.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 27, 2024 05:06 PM
How about this.
IF({Amount},
REGEX_REPLACE(
REGEX_REPLACE(
REGEX_REPLACE(
REGEX_REPLACE(
REGEX_REPLACE(
REGEX_REPLACE(
ROUNDDOWN({Amount},0)&"", "(\\d{3})$", ",$1"),
"(\\d*)(\\d{3}),", "$1,$2,"
),
"(\\d{1,3})(\\d{3}),", ",$1,$2,"
),
"(\\d{1,3}),(\\d{3}),", "$1,$2,"
),
"^(\\d{1,3})(\\d{3}),", "$1,$2,"
),
"^,", ""
)&
"." & LEFT((ROUND({Amount},2)-ROUNDDOWN({Amount},0))*100 & "0", 2)
& " " & {asking-currency}
)
