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

(E-Mail Removed) wrote:
> 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

"Beege" <(E-Mail Removed)> schrieb im Newsbeitrag
news(E-Mail Removed)...
> (E-Mail Removed) wrote:
>> 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

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