#Value! Error when Concatenating
That didn't sound right so I just went in and as a test created a formula
concatenating 2 numbers together:
=a2&b2
No problem. Then I went to Tools/Options/Transitions/Transition Formula
Evaluation and Voila! I got the #Value error. So check that and uncheck it.
--
Kevin Vaughn
"LymaBeane" wrote:
No C13 has a number in it and also D14 does too. There are no formulas
in those 2 cells.
|