Excel Number Format

Celenian
Celenian Member Posts: 15
edited 2007-03-30 in NAV/Navision Classic Client
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

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

    regards
  • Celenian
    Celenian 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

Categories