Excel 2003 - Importing External Data - formatting problem?

J

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!
 
Y

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
 
J

JamieB

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Import External Data 3
Unwanted formatting with imported data 1
Importing txt-file with "." (= dot) as decimal separator doesn't w 2
Excel Import External Data by Date Automatically 0
Fixed Decimals in Excel 2007 4
How do I automatically hide empty columns in Excel? 2
Import Excel data into new Excel spreadsheet 1
Access Problem using dates in a query in access 0

Top