Problem with the button "Send to Excel".

GimoGimo Member Posts: 2
Hi,

I need to see if anyone have manage to solve the problem with the button "Send to Excel" and that the numbers with a space between the thousends will not become numbers, only text. It works to fix the space for thousends in the regional settings for all other export to Excel but not the you click on the button "Send to Excel", see enclose picture (the button in the middle)

Comments

  • mgrzymalamgrzymala Member Posts: 2
    I have exactly the same problem. Export to Excel button inserts the decimal separator characters: either ASCII (Excel 2003) or   (Excel 2007). This makes any calculations on the numbers impossible until you manually get rid of them by Find & Replace.

    Changing regional options in the Control Panel (even by regedit) or editing the NavisionFormToExcel.xslt makes no difference whatsoever (?).
    Can any of You Gurus out there reveal the secret way of fixing this?
Sign In or Register to comment.