Excel Number Format

CelenianCelenian Member Posts: 15
I need to export a file to Excel sheet. Everything is fine, but the requirement is to make numbers formatted with spaces between thousands. I tried such solution:
XlWrkSht.Range(xlColID + xlRowID).NumberFormat('# ##0.00');
but had no particular effect.
Would you please give me some tips on this issue?

Comments

  • advaadva Member Posts: 1
    try this
    XlWrkSht.Range(xlColID + xlRowID).NumberFormat('#'+''''+'##0.00');
    

    regards
  • CelenianCelenian Member Posts: 15
    Further investigation has shown that Regional and Language settings override Number Format settings made in NAV, so this story is far from over...
    Thank you for your attention :D
Sign In or Register to comment.