#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
will
work but most give me the #Value! error. I am using the 2003 version
of Excel. Does anyone know why this is happening? There are no
formulas in these two cells.

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





Thanks
 
L

LymaBeane

both are numerical fields. Yes I tried the = c13&D14. On some it
works but most it brings back a #Value! error. There are no formulas
in these two fields I am trying to concatenate.
 
B

Beege

Lyma

Try using Tools/Formula Auditing/Evaluate formula

I might reveal to you what is happening...

Beege
 
L

LymaBeane

I just now tried that but all it shows is the cell I am using
underlined, it doesn't show what the problem is. This is driving me
nuts.
 
L

LymaBeane

When I did the evaluate formula, I notice on the correct one, it shows
the field in quotes. On the one that gives me the error it shows it
without quotes even though the actual numbers don't show quotes. I
notice if I put an apostrophe in front of the number, the concatenation
works. Are you supposed to always do that with numbers? I never had
to before. Just wondering if it is a weird glitch or something.
 
B

Beege

Check your other post in worksheet.functions

Tools/Options/Transition
Uncheck Trasition Formula evaluation

Beege
 
V

vwyatt

Beege,

Thank you so much for the tip - unchecking Transition Formula
evaluation. I have looked everywhere to get rid of the #value...

Thanks again.
Vwyatt
 
Top