View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kevin Vaughn
 
Posts: n/a
Default #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.