here is a fix for csv files in excell !
Posted: Thu Oct 09, 2003 2:05 pm
ok here is a cool fix for csv files in excel not being read right.
What I am doing is taking data from a submitted for and writting to a csv file. some of the form fields require long numbers that start with 000
ie. 0005621415.
when the files are opend into excel, excel ignores the beginning 0's.
ie. 5621415. or sometime changes to 562+1415
Now the fix....
If the number in the field is written like ="0005621415"
then excel will read the nuber correctly.
I would like my users to only enter the number and not the =" ".
How can I add this to the number variables before the csv file is written.
I also view the csv file in and html formatted table and would need to take out the =" " before it writes the array to html
Any hints or pointers would be appreciated. I know a lot of people have this same issue with csv files and excel so it will help all of us.
What I am doing is taking data from a submitted for and writting to a csv file. some of the form fields require long numbers that start with 000
ie. 0005621415.
when the files are opend into excel, excel ignores the beginning 0's.
ie. 5621415. or sometime changes to 562+1415
Now the fix....
If the number in the field is written like ="0005621415"
then excel will read the nuber correctly.
I would like my users to only enter the number and not the =" ".
How can I add this to the number variables before the csv file is written.
I also view the csv file in and html formatted table and would need to take out the =" " before it writes the array to html
Any hints or pointers would be appreciated. I know a lot of people have this same issue with csv files and excel so it will help all of us.