Excel template settings

If data from Regla is not returned correctly in Excel when a query is made and then saved in an Excel template, the regional settings may not be correct.

Regional settings
It depends on whether you are working on a web version of Excel or the program itself on the machine where the settings are. A good first step is to start by making sure that the Windows operating system is configured correctly, as Excel keeps up with newer versions

Windows
https://support.microsoft.com/en-us/office/change-the-windows-regional-settings-to-modify-the-appearance-of-some-data-types-edf41006-f6e2-4360-bc1b-30e9e8a54989

Excel


Excel web version (Office 365)

https://support.microsoft.com/en-us/office/change-regional-format-settings-in-excel-for-the-web-c206344b-0d45-4a82-8eee-34ff6b008e9c

Excel program (Office 365)

Excel settings should follow Windows settings but can be optimized by configuring templates by:

a) selecting a cell

b) selecting More Number Formats

You can then select the appropriate template

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us