| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#Value! Error when Concatenating
No C13 has a number in it and also D14 does too. There are no formulas
in those 2 cells. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
#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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I start new line when concatenating text strings in excel? | Excel Discussion (Misc queries) | |||
| Concatenating text | Excel Discussion (Misc queries) | |||
| Concatenating Cells | Excel Discussion (Misc queries) | |||
| concatenating and formatting area code and phone number columns | Excel Worksheet Functions | |||
| Concatenating cell values to create sheet names | Excel Discussion (Misc queries) | |||
Hybrid Mode
