|Subject:||Data Import leaves blanks|
|Posted by:||Jeff Giroux (dabung…@nothere.com)|
|Date:||Thu, 27 May 2004|
I have a excel file, for example, that looks like the chart below.
I'll save this file, open a new file, and then on the new sheet try to
import this data. I'll go through the steps of selecting the worksheet and
so on, but then when it imports it looks like below.
Why is that? It doesn't matter how I have my cells setup (General, Number,
Date, etc). This happens to any imports I try to do with the following
1. All the items in a column A (for example) have all contained nothing else
but numbers (or nothing else but letters)
2. Some of the cells in column A are a mix of numbers and letters (4005a for
This also happens the other way around too. Say I start my sheet like
When I go to a new sheet and do the data import, I get the results below.
Why? I can't figure it out. Please, any suggestions would be great.