Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .