Cells switching format


Hi Community, is there a way to prevent a cell from switching it's format?

In my case I am entering "1469831001" as a number with an "R" at the end --> 1469831001R

but the cell switches to currency RAND and I get R1 469 831 001,00 as a result, which I don't want to have.

The colum type itself is set to Text/Number....

Thanks for any help


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!