Excel Cell Number format issue while saving RTC report

shettarvikas

Hi,

When we save a rtc report (Eg. Trial Balance) in excel, the Amount field (or any other number field) in the report is saved as text format in excel. Not as a Number format.

For some reports (like Bank Book), saving the report in excel works fine as the amount fields are saved in number format in excel.

how to resolve for those reports where number fields are stored in text format in excel.

Thanks & Regards,
Vikas