Auto Conversion of Format while exporting data into excel using Macro

[#1]

Hi All,

I am having one field in straight 'Account ID' in straight table having values like 'R0000663869' but while exporting into excel, the column is showing value as 'R 663 869'. Kindly Suggest as what needs to be done to get the same value in exce

[ektarathi]

I am have same issue where leading zeroes in emplid field is dropped while exporting to excel using macro.If you get a solution. please let me know.Thanks!!