A
Alchemist
Hi,
I have a CSV file which data extracted from a backend database.
I noticed this CSV file when open in excel 2003 on different machine give
different result.
The raw data of the CSV file, the text for one particular cell consists of
a charactor ASCII (10).
The way i open the excel file is by doing a double click on file explorer.
The different result is as below:
(1) When i open in 1 machine ( with excel 2003 SP2 installed ), the contents
of the cell displayed nicely with format in 'wrap text' .
(2) When I try on another machine (with excel 2003 Sp3 ), the text is not
wrap but it become a line break instead, making the contents after that move
to the next row.
I had been trying to trouble shoot by doing a data import wizard using
File->Open.
I leave the code page as Windows(ANSI) unchange, and delimiter as 'TAB', the
result is just like (2) , the char(10) had been treated as a line break.
Is it something to do with the different in service pack ?
Can anyone let me know how could i make the result just like in (1) in
machine 2 ?
Please help.
I have a CSV file which data extracted from a backend database.
I noticed this CSV file when open in excel 2003 on different machine give
different result.
The raw data of the CSV file, the text for one particular cell consists of
a charactor ASCII (10).
The way i open the excel file is by doing a double click on file explorer.
The different result is as below:
(1) When i open in 1 machine ( with excel 2003 SP2 installed ), the contents
of the cell displayed nicely with format in 'wrap text' .
(2) When I try on another machine (with excel 2003 Sp3 ), the text is not
wrap but it become a line break instead, making the contents after that move
to the next row.
I had been trying to trouble shoot by doing a data import wizard using
File->Open.
I leave the code page as Windows(ANSI) unchange, and delimiter as 'TAB', the
result is just like (2) , the char(10) had been treated as a line break.
Is it something to do with the different in service pack ?
Can anyone let me know how could i make the result just like in (1) in
machine 2 ?
Please help.