Excel 2003 - Importing External Data - formatting problem?

[JamieB]

I have a spreadsheet that I have been importing data into (from another Excel
spreadsheet). Everything was going smoothly with importing (text in some
columns, dates and numbers in others) until data in one of the columns
changed. The data used to be only a (work order) number. Now, the entries
have a letter or two before the number. None of the newly formatted work
order numbers (for example, T00058) are populating in the spreadsheet, the
cells are blank. If I change the number to "58", it will transfer, but not
with the T in front. Please help!

 

[YESHWANT]

it looks like there is problem with formatting of the cells. look into the
formatting aspect and i think your problem can be resolved

 

[JamieB]

Would it be a problem with formatting in the imported data or formatting in
the destination spreadsheet?