Data Import leaves blanks

Giganews Newsgroups
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.
      4000
      4001
      4002
      4003
      4003a
      4004

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.
      4000
      4001
      4002
      4003

      4004

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
circumstances.
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
example).

This also happens the other way around too.  Say I start my sheet like
below.
      4000a
      4000b
      4000c
      4001
      4001a
      4001b

When I go to a new sheet and do the data import, I get the results below.
      4000a
      4000b
      4000c

      4001a
      4001b

Why?  I can't figure it out.  Please, any suggestions would be great.

-Jeff

Replies