Text import drops commas and periods

  • Thread starter Thread starter Brent Myers
  • Start date Start date
B

Brent Myers

I have noticed that excel 2000 and 2002 will occationally
drop a comma from a comma delimited file, shifting that
record to the left one column. I handled this in the past
by quickly scanning an imported text file to make sure
that each record is properly aligned. Not a problem with
files of up to a few thousand records.

Now, after recently upgrading I find that Excel 2002 is
ocasionally dropping the decimal from the last column in
a very few records on import. There is no way I can
easily check for dropped decimals. Are these problems a
known issue with Excel 2002?

The dropping decimals is not acceptable, any ideas for a
fix? I am completely up to date with all service packs,
running Windows XP.
 
I've never seen this.

Can you reproduce it on demand? If yes, can you post some of the data that
makes it fail (not the workbook)?

And can you post your steps that make it break?
 
Back
Top