Hello,

My boss seems to be able to enter numbers into cells that are formatted as Text, yet they will automatically be recognized as numbers when referenced in a formula,

however when I enter numbers into a cell formatted as Text, they aren't immediately recognized as numbers and I have to convert them.



Obviously it would save time to not have to convert them to numbers manually every time we enter info and clearly, somehow, my boss' computer is set up such that numbers are immediately recognized, even when entered into cells formatted as Text.


Can anyone guide me towards understanding what is going on here or how I could easily enter numbers that will be recognized as numbers by a formula?