### Tags: concatenate, concatenating, error, excel, fields, microsoft, msdn, numerical, software, together, value

# #Value! Error when Concatenating

On Microsoft » Microsoft Excel

3,780 words with 8 Comments; publish: Thu, 22 May 2008 04:40:00 GMT; (30692.77, « »)

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

*http://excel.todaysummary.com/q_microsoft-excel_2582.html*

All Comments

Leave a comment...

- 8 Comments
- Lyma,
Did you try

=C13&D14

?

What are in C13 and D14? Formulas?

Beege

"LymaBeane" <l-tater.excel.todaysummary.com.cox.net> wrote in message

news:1142887980.630152.140540.excel.todaysummary.com.i39g2000cwa.googlegroups.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

> 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

>

#1; Thu, 22 May 2008 04:41:00 GMT

- Lyma,
- 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.

#2; Thu, 22 May 2008 04:42:00 GMT

- both are numerical fields. Yes I tried the = c13&D14. On some it
- Lyma
Try using Tools/Formula Auditing/Evaluate formula

I might reveal to you what is happening...

Beege

"LymaBeane" <l-tater.excel.todaysummary.com.cox.net> wrote in message

news:1142888640.754042.241290.excel.todaysummary.com.t31g2000cwb.googlegroups.com...

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

>

#3; Thu, 22 May 2008 04:43:00 GMT

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

#4; Thu, 22 May 2008 04:44:00 GMT

- I just now tried that but all it shows is the cell I am using
- 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.

#5; Thu, 22 May 2008 04:45:00 GMT

- When I did the evaluate formula, I notice on the correct one, it shows
- Check your other post in worksheet.functions
Tools/Options/Transition

Uncheck Trasition Formula evaluation

Beege

"LymaBeane" <l-tater.excel.todaysummary.com.cox.net> wrote in message

news:1142889684.072499.119320.excel.todaysummary.com.u72g2000cwu.googlegroups.com...

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

>

#6; Thu, 22 May 2008 04:46:00 GMT

- Check your other post in worksheet.functions
- There were no other replies in my other post. But yours worked.
Thanks so much!!

#7; Thu, 22 May 2008 04:47:00 GMT

- There were no other replies in my other post. But yours worked.
- 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

vwyatt

---

vwyatt's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=33048

View this thread: http://www.excelforum.com/showthread.php?threadid=524556

#8; Thu, 22 May 2008 04:48:00 GMT

- Beege,