|Subject:||Data format problem when open CSV using Excel|
|Posted by:||Alan Choy (choy_al…@hotmail.com)|
|Date:||17 Oct 2003|
I have a CSV file which contains some data such as "5603000E00". When
I used Excel to open the CSV file, this data is presented as "5.6+E06"
as Excel thinks it is an scientific number. If I used format cell
function to change it back to Text, it will present is "5603000".
Is there anyway to have the data present as "5603000E00" instead?