1 person found this helpful
I assume that you mean that when you open the CSV in Excel you miss the trailing zero's
I think that Excel thinks that the values are numbers despite them being surrounded with " in the csv. See if you can change any settings to excel so that values of a csv that are surrounded with a " are always seen as text even when it is recognized as a number.
This is a Excel problem not an APEX one. I don't work with Excel so I can't help with the settings you need.
You are correct Nicolette. It's a Excel problem, Is there any other way to fix this through PL/SQL. so only i come up with this question.
I did some workaround in excel to display the correct value without trailing the zeros. Problem is solved now.
I think there is no other way to fix this from PL/SQL.