I have Excel 2000, where this seems to work with no trouble. But apparently
what you are seeing implies 2003 is stricter in dealing with cell types, so
you cannot concatenate a number to text without converting it first. When
you save as .csv, it becomes a text file and I assume is interpreted as text
when imported. You can test that by using the ISTEXT() function on the cell
both before and after the export/import, but that is what appears to be
happening.

I prefer how 2000 handles it!
--
- K Dales


"HSalim[MVP]" wrote:

I have a rather strange issue that I don't recall encountering ever before.
using Excel 2003
I have text in Column A and a number in Column B, and the formula = A2 & B2
results in an error with #value being displayed
Same result if I use Concatenate...

if i save as a CSV, now try this after opening the file in Excel, no
problem.

What have I done to this file that it is giving me these odd responses?
Regards
Habib