When copying data between Business Central and external systems (e.g Excel) it is important to ensure your Language and Regional Settings line up to avoid issues. Below details the setup we have found to work best.
In Business Central your Region and Language options should be set to the following:
On Windows ensure your settings reflect the following: