CSV File format problem

[plmanikandan]

Hi,
I have a .csv file with following data

No,Name
0001,ii
0002,ww

I need to change the csv file in excel and insert into a database thru
my c# programs.
The "No" column is rounded off when i opened in excel and it is shown
as 1.
Is there any settings to change this type of behaviour
I want to display that "No" column as text in excel by default.
I don't want the trimming of zero in the "No" column

Thanks & Regards,
Mani

 

[Beege]

Hi,
I have a .csv file with following data

No,Name
0001,ii
0002,ww

I need to change the csv file in excel and insert into a database thru
my c# programs.
The "No" column is rounded off when i opened in excel and it is shown
as 1.
Is there any settings to change this type of behaviour
I want to display that "No" column as text in excel by default.
I don't want the trimming of zero in the "No" column

Thanks & Regards,
Mani

Rename your .csv to .txt, import into excel, format No column as
text... HTH

Beege

 

[Thomas Hardy]

Rename your .csv to .txt, import into excel, format No column as text...
HTH

Beege

Spot on Beege,

It is a weakness in Excel that it makes assumptions about your data, even in
some cases when you clearly define a cell as text.

I always download data from other systems with the .txt extension so that I
can keep some level of control.

Regards

Thomas