I have made a package where in I am exporting the SQL data to a Excel. The excel data have a fixed template. I am using the custom format for some particular columns where in I want the digits to be prefixed with a '$' sign and also ',' separated.To do this I have made a cell with the required custom format and below that cell all the required data is copied from SQL. Problem :- But the problem I am facing is that the digits after decimal are getting rounded off to 4 digits Analysis :- a) There is no problem with the custom format as on using the same custom format outside on another excel it is working fine b) There is no problem with the data which is being transferred to excel as when I am exporting the data without the custom formatted it is copying the digits with all the digits after decimal. Please let me know what can be done on this...madhur_ms

I have made a package where in I am exporting the SQL data to a Excel. The excel data have a fixed template. I am using the custom format for some particular columns where in I want the digits to be prefixed with a '$' sign and also ',' separated.To do this I have made a cell with the required custom format and below that cell all the required data is copied from SQL. Problem :- But the problem I am facing is that the digits after decimal are getting rounded off to 4 digits Analysis :- a) There is no problem with the custom format as on using the same custom format outside on another excel it is working fine b) There is no problem with the data which is being transferred to excel as when I am exporting the data without the custom formatted it is copying the digits with all the digits after decimal. Please let me know what can be done on this... madhur_ms ANY SUGGESTIONS WOULD BE REALLY HELPFUL!!!madhur_ms