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.
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.