trprasad78
Member
Hi
Default excel cell format will be in "General"
because of that if i open .csv or .txt file zeros got remove automatically.
Example.
00000535
000000541
its turn to 535 and 541.
I know their is option in Text Column where i can choose Field type as "TEXT"
But I want to avoid this process , once we open it has to open as TEXT format.
so can we change the default text format from General to TEXT ?
OR
if you have any alternative way, where if we double click .CSV or .TXT file it has to open with proper format.
Please suggest.
Default excel cell format will be in "General"
because of that if i open .csv or .txt file zeros got remove automatically.
Example.
00000535
000000541
its turn to 535 and 541.
I know their is option in Text Column where i can choose Field type as "TEXT"
But I want to avoid this process , once we open it has to open as TEXT format.
so can we change the default text format from General to TEXT ?
OR
if you have any alternative way, where if we double click .CSV or .TXT file it has to open with proper format.
Please suggest.