I am trying to retain the formatting of a number field while changing it to a text field. For example:
Number field shows with formatting = “1,234.5”
I create a new text field with the number and add " kg" to the end with a formula
The new field should show “1,234.5 kg” on my reports
Unfortunately, the new field shows “1234.56789 kg” because the original formatting of the number is not retained.
Is there a workaround for this?