In earlier versions of Excel when I would put an = sign I could do a formula such as:
= "Hello" & B2
and it would display as, for example:
Hello1234
In 2010 sometimes it does the above but sometimes it just displays the formula, for example:
= "Hello" & B2
I've ensured the cell formatting is the same as the one that works and it is.
This is very frustrating.
Anyone know what is going on?
Thanks!