Format of External Doc. No(CODE) is getting changed as DATE format in Export to Excel functionality.

Hi All,

Format of External Doc. No(CODE) is getting changed as DATE format in Export to Excel functionality.

Only for some invoices its changing the format of Ext.Doc.No for all.

Example. Ext.Doc.No 1234/12-13 if i copy this into a excel sheet its coming as 13/12/34. Not for all the invoices only for some invoices .

please help me in solving this.

Thank U

Use below code while exporting External Doc. No

‘’’’ + FORMAT(“External Doc. No”)

4 single quotes…