Excel Number Format

Celenian

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?

adva

try this

XlWrkSht.Range(xlColID + xlRowID).NumberFormat('#'+''''+'##0.00');

regards

Celenian

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