Export Data Thru Excel- Cell Formating Problem


i am generating my report and exporting data in excel format.

problem is that : in my excel sheet some of data is like 5/6, 8/5, 2/3 and all.

but in excel sheet that cell will take it as a date format.

one more thing that i want to share is that i have already use '(apostrophy), " " , () and all.

it works but main thinf is when i am click on that cell it will show me as '5/6 , or “5/6” , or =“5/6”.

i have used extension XPHPExcel but still i face the the same problem …can anyone tell me proper and simple way to solve my problem…

and if any extension usage then pls give proper path so newly member can understand…

hope u understand…