Hi Daxer's

Today i come up with a small post but important and useful trick to save time for the developer,when we are exporting data from Ax to Excel sheet,if any record is having data staring with zero (i.e 00021).

Excel will read it as "21" to over come this issue use below code

  xlsWorkSheet.cells().range('A:A').numberFormat("@");

  xlsWorkSheet.cells().item(row,1).value(strFmt("%1",worker.PersonnelNumber));