Change Number to Text field but retain the number formatting

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?


You could try using formula to transfer the number to text field, such like TEXT(A1,####.#)+" KG".
Or if you need maybe ROUNDUP() or ROUNDDOWN(), please just add to the formula.

Works great! Thank you~