number can not converted to text really in excel

[lezawang]

Hi
I have a number 416 aligned to the left side of cell A1 and there is a green rectangle in the cell so this number is formatted as a text. So far so good. when I do

=A1+1

Then excel will return 417 as number (aligned to the right)

If I had "hello" in A1 and then I do

=A1+1, I will get #Value error message

So why excel did not consider 416 as a text and refuse to add it to 1 and give #Value error? Thank you so much.

 

[Fluff]

If you try to do a mathematical calculation on a text value, Xl will try to convert the value to a number.