concatenate two columns of numbers does not produce concatenated value

**welchs101** · 02-26-2013, 04:17 PM

Hi,

i am enclosing excel macro which basically has 3 cols..........the third col is basically a concatenation of the first two cols where both cols are numbers. The resultant column is a number but its not the "TRUE" concatenated value........

any ideas?

example:
ColA= 20070337
ColB= 10002
ColC= 2.00703E+12

i want col C to equal 2007033710002

**AB33** · 02-26-2013, 04:25 PM

Please Login or Register  to view this content.

This works as long as the data is formatted in fraction

**jaslake** · 02-26-2013, 04:41 PM

Hi welches101

Format Column C as Number, 0 decimal places...

**welchs101** · 02-27-2013, 07:51 AM

thanks for the info...............

i was wondering "WHY" excel did not display the number as the full number but instead a rounded scientific number.

any thoughts.

**jaslake** · 02-27-2013, 01:50 PM

Hi welches101

From http://office.microsoft.com/en-us/ex...003064132.aspx

the General format does use exponential notation for large numbers (12 or more digits). To remove the exponential notation from large numbers, you can apply a different number format, such as Number.