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?

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.

MIKE

You do have an equal sign in front of the =A11 ? Is it really showing

'=A11'

with the single quote marks?MIKE

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.

Ask Your Question

Weekly Poll

Did you buy anything on Amazon's Prime Day?

Discuss in The Lounge

Poll History