If you're using xl2003, then you're using a MAC, right?

Maybe it's a difference in the way the MAC/Unix and Windows/DOS treats end of
lines.

In the Windows world, an end of line marker is Carriage Return followed by a
Line Feed (CrLf). In the MAX/Unix world, (I think) it's just a Line Feed.

Maybe your text editor is smart enough to do the conversion from Lf to CRLF.



Sujesh wrote:

Hi!!!
I am faced with a strange problem. A program generates incremental numbers
and writes to a .csv file. If there are more than 60,000 records, it writes
60,000 records into one file and the remaining records into another file. i.e
it makes each file of 60,000 records or less. One file that I have has about
16460 records. When I open the file in Excel, it shows the count as 16322,
but when I open it in a text editor like Wordpad or Textpad, it shows me the
correct number as 16460 records.

Why does Excel behave like this? Siince I cannot attach files here, if
needed, I can mail the files for your review.

Pls help.

Sujesh R. Nair

--

Dave Peterson