I can't fix a simple Concatenate formula that won't display it's result
(tried turning Formula Auditting mode on & off).
When I do an "Evaluate Formula" on the cells that formulas are not
displaying values in I get the following
error: The cell currently being evaluated contains a constant".
The formual looks identical to ones in cells above and below (except for
cell #'s that do work fine.
The data referenced in the formula looks fine.
This one works:
=CONCATENATE("SHOULDER BOLT ", A6," DIA X ",B6," L X ",H6,)
This one doesn't:
=CONCATENATE("SHOULDER BOLT ",A12," DIA X ",B12," L X ",H12,)
How can I fix this problem?
Gary
GC - 31 Jan 2007 00:57 GMT
BTW- I'm using Excel in Office 2003
Dave Peterson - 31 Jan 2007 01:28 GMT
They both worked ok for me.
What does the second one evaluate to?
Maybe you have tools|options|calculation tab|set to manual????
Maybe the cell is formatted as text???
> I can't fix a simple Concatenate formula that won't display it's result
> (tried turning Formula Auditting mode on & off).
[quoted text clipped - 17 lines]
>
> Gary

Signature
Dave Peterson