When I am exporting to Excel from a grid view, the currency fields are displayed in Excel with a $ sign. How can I control this? Extended properties of the application are set to "UseWindowsCulture”. However no matter what kind of language settings in Windows I change, I do not succeed to display the € in Excel. The cell property in Excel is set to $ #.##0,000 during export. While the currency setting in Excel is set to display € sign.
Best answer by Erwin Ekkel
The currency sign is currently determined by the user language. You probably have the user set to English. English will give a dollar sign in excel export and Dutch will give you a Euro sign.
You can change this if you change the local currency sign in region settings for english (united states)
The currency sign is currently determined by the user language. You probably have the user set to English. English will give a dollar sign in excel export and Dutch will give you a Euro sign.
You can change this if you change the local currency sign in region settings for english (united states)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
