software

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?

ThanksWhat's your formula?

--
Kind regards,

Niek Otten

quot;LymaBeanequot; gt; wrote in message oups.com...
gt;I am trying to concatenate two fields together. They are both
gt; numerical fields. I have never had a problem but for some reason some
gt; work but most give me the #Value! error. I am using the 2003 version
gt; of Excel. Does anyone know why this is happening?
gt;
gt; Thanks
gt;
I tried C13amp;D14 and I also tried =concatenate(C13,D14) and even
=concatenate(C13amp;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

quot;LymaBeanequot; gt; wrote in message ups.com...
gt;I tried C13amp;D14 and I also tried =concatenate(C13,D14) and even
gt; =concatenate(C13amp;D14) but I keep getting the #Value! error.
gt;
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:
=a2amp;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 Vaughnquot;LymaBeanequot; wrote:

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