A Problem in CSV file

[Vish]

Hi Friends,

In my CSV file,I have a column where the data can be upto 1 to 2
characters. But when I open the file, the data in the column comes i
exponential format for some entries. But when I open the same CSV fil
with notepad all the entries are coming properly.

Here is one example.
The entry 65080001031001510000000 is appearing as
6.50800010310015E+22

When I try change the format to text also it still shows the sam
exponential format.

Can you please suggest me how to solve this problem easily

 

[Andy B]

Vish

One way is to change your file from a .csv to a .txt. That way, you can tell
the Text Import Wizard that the column you mentioned is actually text.

Andy.

 

[Paul]

Hi Friends,

In my CSV file,I have a column where the data can be upto 1 to 23
characters. But when I open the file, the data in the column comes in
exponential format for some entries. But when I open the same CSV file
with notepad all the entries are coming properly.

Here is one example.
The entry 65080001031001510000000 is appearing as
6.50800010310015E+22

When I try change the format to text also it still shows the same
exponential format.

Can you please suggest me how to solve this problem easily.

Change the file extension from .csv to .txt. Then when you open it from
Excel, the import wizard will run and you should be able to choose to import
as text. (Note that this is not the same as changing to text after having
opened a .csv file.)

 

[Vish]

Thanks a lot Paul. Solution is working great..
But is there any other way of doing this without changing the file type
?

 

[Paul]

Thanks a lot Paul. Solution is working great..
But is there any other way of doing this without changing the file type
?

Not as far as I know, but I'm quite happy to be corrected if anyone knows
better!