Hi,

Through my application i am generating csv files which are my reports.
In that report some data like amount ,a number..etc are there.

When the report gets generated & i open this CSV file in excel , i am not getting the exact data i wrote to the file , that is :

If there are any preceding ZEROES in the number they gets truncated (for e.g 050123 tehn only 50123 is wrote) OR in the case of AMOUNT if the amount is of the form 1200.00 then only 1200 is written, I mean this the problem i am facing with the leading & trailing zeroes in the figures if i m not mistaken??

So is there any way to format this report AFTER GETTING GENERATED using java??

Thanks,
Jignesh