I enter this formula into C2 ="Y329/"&b2

and In C2 I get the same answer ="Y329/"&b2

In other words for some reason excel is not seeing it as a formula but as a
text string.

Does anyone know why this is happening? Have I turned on an option
accidently?