Data format problem when open CSV using Excel

Giganews Newsgroups
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?

Replies