This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hi,
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 f...
@W_Vann_Hall Thank you for your reply! Indeed, I noted a construct I hadn’t seen documented anywhere. How to use &"" to coerce a value into a string. The rest was dealing with LEN and REPLACE and similar. My solution doesn’t work for every edge case,...
