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

What's your formula?

--
Kind regards,

Niek Otten

"LymaBeane" wrote in message oups.com...
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

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

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

--
Kind regards,

Niek Otten

"LymaBeane" wrote in message ups.com...
I tried +C13&D14 and I also tried =concatenate(C13,D14) and even
=concatenate(C13&D14) but I keep getting the #Value! error.

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

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.