Problem with Excel port

grofs

Hy,
I use NAV 5.0 Hungarian version,
I click Excel Export (3 colums, Code, Description, Balance)
Code and description are perfekt, but Balance (it is decimal type in NAV) isn't decimal type in Excel. Meet with this problem anybody?

or know the solution?

kine

The problem is in most cases the thousand separator. There are two solutions:

1) Replace the thousand separator in the excel with nothing or space (take the char from some amount >1000 by Ctrl+C and pass it into the replace dialog through Ctrl+V, it is not common space, it is fixed space).
2) Go into regional settings in control panels and change the thousand separator to space. After that and restarting PC when you export the data it should be ok.