Concatenating two numbers

**BWellman** · 07-25-2016, 10:37 AM

Hello,

I am wondering why concatenating two numbers does not work, and maybe for a different approach if you have one.

If I have two numbers 10 and 5, and I concatenate them (trying to show 105, not 15), the true value is not 105 (it doesn't work in a >= formula). Could someone please explain this to me, Google has been unhelpful :P

I built a depreciation table that is broken because you are not able to concatenate two numbers. In the attached file, the "coef" values in row 7 are a combination of year and month values concatenated. The table below assigns a weekly depreciation value if the period or "coef" value is after the purchase date, but before the end of the asset's life.

As you can see in the attached file, it breaks when the values in column "H" hit 1000.

Thanks,
Blake

**AlKey** · 07-25-2016, 10:43 AM

To concatenate two numbers in from two cells

Formula:

Please Login or Register  to view this content.

v	A	B	C
1	10	5	105

**alansidman** · 07-25-2016, 10:47 AM

Try this in K7 copy accross: =CONCATENATE(K3,K5)*1

**MarvinP** · 07-25-2016, 10:49 AM

Hi Blake,

We both know that 10 + 5 is 15 and that is using the values of those numbers. When you Concatenate you are no longer using numbers, you are treating those numbers as letters and putting them together. If you wanted to turn the letters of 105 back to a number in Excel you could add a zero to it. The last operation to a cell converts it between threated as a number or a bunch of letters. Excel needs to know if the cell ISNUMBER or ISTEXT.

It looks like you are using these cells as numbers and want to extract the month or year for your calculation. Dates are really numbers in Excel. Excel starts day 1 in its counting as Jan 1, 1900 as Day NUMBER 1. To convert these number of days since 1/1/1900 and text you need to use Date type functions. You need to use the Date() and DateValue() functions.

When you claim your formula "breaks" at 1000, I'm hoping the above information will help explain it. What should the value in Column H be when it "hits 1000"?

Concatenating two numbers

LinkBack

Thread Tools

Rate This Thread

Display

Concatenating two numbers

Re: Concatenating two numbers

Re: Concatenating two numbers

Re: Concatenating two numbers

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Concatenating two columns and reversing after concatenating the result

Concatenating numbers as text and retaining text format

Concatenating together a series of IF statements to diplay a conditional list of numbers

Need formula for concatenating and rounding up numbers into one cell

Concatenating strings and numbers

Concatenating and transposing a row of numbers

[SOLVED] concatenating numbers

Bookmarks

Bookmarks

Posting Permissions