CSV File format problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

plmanikandan@gmail.com - 14 Feb 2007 17:16 GMT

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

Reply to this Message

Beege - 14 Feb 2007 17:21 GMT

> Hi,
> I have a .csv file with following data
[quoted text clipped - 13 lines]
> Thanks & Regards,
> Mani

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

Beege

Reply to this Message

Thomas Hardy - 14 Feb 2007 18:48 GMT

>> Hi,
>> I have a .csv file with following data
[quoted text clipped - 18 lines]
>
> 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

Reply to this Message