Stop Excel from changing cell contents, ever
- by Enable Manual-Correct
I work with card numbers, like credit card and ID numbers. We do not do any calculations with card numbers, obviously. They are "text."
I format them as text, I type them like text. I know how that works. Excel doesn't care. 16 digit card numbers get their last digit turned into a zero, changed into scientific notation, stupid stuff that I did not…