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
Check out the Formula Handbook template!