I have a Formula field where I concatenate text from a Price field to create a currency string (text) for further copy and paste purposes.
When I concatenate the Price field, I get the floating number instead of the formatted price.
Price field formatting: $ 18,322,511.53
Formula field string I get: 18322511.5264
Now, I know I can concatenate the “$” symbol. However, I don’t know how to format the number itself to allow for commas and decimals.
Do you know how?