Here's what I found: if I have some cells with valid numeric entries such as
=3+4 and then apply the ribbon command
HOME/Number/Text , the format of the cell itself follows the rules for text, such as center vs. left alignment. However, the formula remains valid and the cell displays the result (
7) . Further, if I turn on
DATA/Filter, the filter pop-up menu includes the "Number Filter" option and not the "Text filter" option.
However, if I first select empty cells and apply
HOME/Number/Text , and only then enter numbers into the cells, the formula is not processed, and the Filter option displayed is "Text filter." This suggests to me that the Number formatting tool doesn't re-evaluate what's already in the cell. Is this a bug, or is there some reason this was intended to happen?
FWIW, this is in Excel Office Professional Plus 2013 .