#Value! Error when Concatenating

L

LymaBeane

I am trying to concatenate two fields together. They are both
numerical fields. I have never had a problem but for some reason some
work but most give me the #Value! error. I am using the 2003 version
of Excel. Does anyone know why this is happening?

Thanks
 
L

LymaBeane

I tried +C13&D14 and I also tried =concatenate(C13,D14) and even
=concatenate(C13&D14) but I keep getting the #Value! error.
 
N

Niek Otten

The only thing I can think of is C13 or D14 is #VALUE! already.
Are they formulas?
 
L

LymaBeane

No C13 has a number in it and also D14 does too. There are no formulas
in those 2 cells.
 
K

Kevin Vaughn

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.
 
Top