web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Microsoft Dynamics AX ...
Microsoft Dynamics AX (Archived)

Microsoft Dynamics AX Add-in for Word: Locals (regional settings)

(0) ShareShare
ReportReport
Posted on by PA-22040759-0 6,194

What controls the locale when I create a Word document with the Office Add-In for Word?

If I for example want to make a quotations for a customer, I'd want the date format and decimal formats to be in the locale of the customr.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member on at

    Date format depends on the regional settings of the client computer. They are defined in the control center.

    You can also define decimal formats there. I didn't try if they apply for AX, but i guess so

  • PA-22040759-0 Profile Picture
    PA-22040759-0 6,194 on at

    That doesn't seem to be the case with the Office Add-In here.

    I'm getting US decimal points on a development machine with settings for Denmark in the Control Panel. Client and AOS are on the same machine.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 307,376 Super User 2026 Season 2 on at

    Hi Palle,

    I have seen this behavior as well. It looks like it just drops the database format. Are you using a Danish version of Word or an English? I have not tried to play with setting another proofing language in Word. Maybe you can indicate if this will work out or not.

  • Community Member Profile Picture
    Community Member on at

    Just tried, it does work on my AX 2012 R2 CU7.

    There is just something strange about the decimal format:

    I am logged in to my virtual development machine using RDP. The date format is applied via the virtual machine settings.

    Using the Excel Office Add-In, the Excel from my local machine opens (there is no office installed on my virtual machine).

    For the decimal format i had to change the region settings on my local machine, where excel is installed.

    What version are you using? According to technet something changed in R2, although it only mentions language settings:

    technet.microsoft.com/.../dn507091.aspx

  • PA-22040759-0 Profile Picture
    PA-22040759-0 6,194 on at

    I'm on AX 2012 R2 CU7. Word is English.

    Changing the proofing lanuage doesn't change the formatting.

    I can see that the inserted "fields" are Word content controls, but they don't leave me much options to change to format.

  • PA-22040759-0 Profile Picture
    PA-22040759-0 6,194 on at

    Guys, I found this:

    KB 2976705 Data imported into a Microsoft Word document is always formatted in EN-US currency and decimal format

    That's a fix that applies to R2. So I'm gonna try that.

  • Suggested answer
    PA-22040759-0 Profile Picture
    PA-22040759-0 6,194 on at

    KB 2976705 fixes the issue :-)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans