Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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:


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?


share|improve this question

migrated from Jun 1 '11 at 14:07

This question came from our site for professional and enthusiast programmers.

This cell might be set as 'text'. It needs to be set as 'general'.


Edit: I haven't seen you had checked the format, sorry.

Edit #2: Got curious and dig a while about your problem. Have you checked if B2 is also set as Text? It seems that when doing a direct reference to a cell, the cell format is also moved along with the value.

Try to add a function over the value (i.e. = "Hello" & left(B2,1)).

This idea came from THIS link.

Hope it helps!

share|improve this answer
Yeah, formats are the same. Thanks for commenting though. – user390480 Mar 7 '11 at 19:14
@user390480 improved my comment... hope it works now :) – Tiago Cardoso Mar 7 '11 at 20:33

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.