Problem linking cell in Exel

Microsoft Office excel 2007
November 3, 2010 at 11:17:40
Specs: Windows 7
Within cell A36, I'm trying to reference a cell on my spreadsheet, =A11. In cell A35 I've got a formula: =concatenate(A36, "compared to placebo"). I'm finding that rather than referencing and showing the contents of A11 (should by 'cYTA'), cell A36 simply shows '=A11' and cell A35 shows '=A11 compared to placebo'. I've tried changing the cell formatting, typing the formula in vs. clicking on the cell I want referenced, copying contents of the entire tab to a new tab (and a new workbook). Anybody have any brilliant suggestions?

See More: Problem linking cell in Exel

November 3, 2010 at 12:18:19
Don't know what's going wrong, but your formula:

=concatenate(A36, "compared to placebo")

worked for me. Excel 2007

I put the text string "cYTA" in cell A36 and entered your formula in cell A37

I then referenced cell A37 in B37 using the formula =A37

and it worked fine.


Report •

November 3, 2010 at 12:26:00
You do have an equal sign in front of the =A11 ?

Is it really showing '=A11'
with the single quote marks?


Report •

November 3, 2010 at 20:15:59
Excel is notorious for locking a cell into Text format and never letting go. When that happens, it doesn't see your formula as a formula, but as a text string.

Try this (no guarantees):

Select an empty cell and Copy it

Select the cell that contains =A11 and do an Edit...PasteSpecial...Add

Either this will solve the problem or you'll get a #VALUE error.

If you get a #VALUE error, look in the formula bar and you should see something like:

=A11 +0

Delete the +0 and see if that helps.

What this should (hopefully) do is force Excel to apply a number format to the cell, removing the Text format and allow it to accept a formula.

Like I said, no guarantees.

Report •
Related Solutions

Ask Question