CSV File format problem

P

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
 
B

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
Click to expand...
Rename your .csv to .txt, import into excel, format No column as
text... HTH

Beege
 
T

Thomas Hardy

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

Beege
Click to expand...

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
 
Top