On the Tools|Options|View dialog do you have "Formulas" checked under
"Window options"?

Also, try formatting the cell as "General" instead of text then re-enter
the fomula.

Did you by chance mean
=Y329&"/"&B2
instead of the formula that you posted?

Jerry

bj wrote:

> 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?