software

I'm using the concatenate function (or the quot;amp;quot;) to combine 2 cells. One cell
is the number 2006 and the other cell is the number 1. I've added a space
using quotes in between so the answer should be quot;2006 1.quot;
In one spreadsheet this works fine. I try the same procedure in another
open spreadsheet but it gives me the #value error. I've even cut the three
cells (the last of which includes the formula) to the new spreadsheet, and it
gives the same error. The links are correct, it just doesn't work
consistently.

Any thoughts?

tia,
Dave


So you're using a formula like

=A1amp;quot; quot;amp;B1

The only reason I can see for a #VALUE! error there is that A1 or B1
contains a #VALUE! error--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=506764quot;Dave Breitenbachquot; gt; wrote...
gt;I'm using the concatenate function (or the quot;amp;quot;) to combine 2 cells. One
gt;cell
gt;is the number 2006 and the other cell is the number 1. I've added a space
gt;using quotes in between so the answer should be quot;2006 1.quot;
gt;In one spreadsheet this works fine. I try the same procedure in another
gt;open spreadsheet but it gives me the #value error. I've even cut the three
gt;cells (the last of which includes the formula) to the new spreadsheet, and
gt;it
gt;gives the same error. The links are correct, it just doesn't work
gt;consistently.

Tools gt; Options, select the Transition tab in the Options dialog, uncheck
Transition Formula Evaluation.
Thanks. That did it. I had always thought that the options you selected
applied to any workbook you were using in that version of excel until you
changed the options.
Can you explain what the transition formula evaluation is attempting to
accomplish?

quot;Harlan Grovequot; wrote:

gt; quot;Dave Breitenbachquot; gt; wrote...
gt; gt;I'm using the concatenate function (or the quot;amp;quot;) to combine 2 cells. One
gt; gt;cell
gt; gt;is the number 2006 and the other cell is the number 1. I've added a space
gt; gt;using quotes in between so the answer should be quot;2006 1.quot;
gt; gt;In one spreadsheet this works fine. I try the same procedure in another
gt; gt;open spreadsheet but it gives me the #value error. I've even cut the three
gt; gt;cells (the last of which includes the formula) to the new spreadsheet, and
gt; gt;it
gt; gt;gives the same error. The links are correct, it just doesn't work
gt; gt;consistently.
gt;
gt; Tools gt; Options, select the Transition tab in the Options dialog, uncheck
gt; Transition Formula Evaluation.
gt;
gt;
gt;

quot;Dave Breitenbachquot; gt; wrote...
....
gt;Can you explain what the transition formula evaluation is attempting to
gt;accomplish?
....

I could, but you'd get a more complete answer by pressing [F1] to bring up
online help, then search its index for the keyword transition.