Cell shows formula and not the result of the formula.

S

stumpy1220

I have a simple workbook with names and address. In cell B2 I have the
following formula, =CONCATENATE("Attn: ",E2)
This is what shows in the cell, not the result of the formula. I have the
formula =SUM($G2:$R2) formula in cell F2 and it shows the results ok. When
you first type the formula a popup window shows up to help, the results show
correctly in this window, just not in the cell?????
 
T

tjtjjtjt

Press Ctrl+`
That's the Ctrl Key and the button that's frequently directly below Esc.

tj
 
N

Niek Otten

See my answer to your earlier post

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying formulas across columns 2
Adding cells until they are greater than a lookup cell and returning a value 1
formula displays as a formula, not as its result 1
Show a cell's formula in text format in a linked cell 2
Copy the content of a cell with Formula 1
Cell shows formula and not the result of the formula. 2
Would like to input 3 letters into a cell, each having a different numerical value 5
Combing a V Lookup result with ("00"&A2)*1 in same formula 4

Top