| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concantenate numeric fields
A report lists in 2 columns an account number and a sub-account number as
numeric fields. I want to concantenate these fields. when I use "=CONCATENATE(B7,C7)" I get a #VALUE! error message. If I place a ' infront of the numbers in B7 and C7 then it works fine. Is there any way to use the concantenate function without inserting the ' infront of a few thousand fields? Changing the cell format to text has not worked. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return Matched Numeric Values across Rows | Excel Worksheet Functions | |||
| Find and Return Numeric Label based on (Numeric Value) Criterion | Excel Worksheet Functions | |||
| Find and Count Frequency of Numeric Value in Non-Contiguous Rows | Excel Worksheet Functions | |||
| Match 3 Criteria and Return Lowest Numeric Value | Excel Worksheet Functions | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
Threaded Mode
