xl2k on w2kPro.
My macro is creating a "Key" field that is made up of a concatenation of two cells.
The first cell is seven digits, the second varies between 2 and seven digits.
The cells are on a CSV workbook.

I insert the Key column and create the Key with;

"SrcSht.Cells(i, 1) = SrcSht.Cells(i, 2) & SrcSht.Cells(i, 3)"

The resultant display will vary as follows;
Key Field 1 Field 2
1E+11 1000001 29830
1000002309 1000002 309


The reasoning behind this is beyond me although, for this app, it doesn't matter as a
lookup has no problem finding the key and the "=" entry area displays the correct value.
Also, if I do the concatenation using the UI (Field1 & Field2) all is well.
Some results (not all) will come out correctly if I enlarge the column width.

Therefore it appears to be a display anomaly only(?).

--
Regards;
Rob
------------------------------------------------------------------------