32
D

Changing of the Excel Current custom formatting for German (Switzerland)

Danail Danailov on 1/10/2023 3:17:21 PM

For BC SaaS CH, when using the option Edit in Excel has to choose the format differently in Excel, which does not affect the underlying value.

When you have the column of UTC dates, select all of them, and press ctrl+1.

The format cells panel should appear:


Format Cells:


Category: Type:

... ...

Data 14.03.2012

... ...



And instead of the current custom formatting being applied, we have to go to "Date" and pick another Locale and another date format for German (Switzerland).

Category: Geographies and Localization
STATUS DETAILS
Needs Votes
Ideas Administrator

Business Central Team (administrator)

Thank you for your feedback. Currently this is not in our roadmap; however, we are tracking it and if we get more feedback and votes, we may consider it in the future.

Sincerely,
Aleksandar Totovic
PM, Microsoft

Comments

D

D

RE: Changing of the Excel Current custom formatting for German (Switzerland)

Mark Fahrni on 1/11/2023 12:13:57 PM

The issue with the "Edit in Excel" function, which is a great function, is for any localizations. Fields with type date, should be shown as it is in the country specific format. Europe = DD.MM.YYYY


Today, all the dates shows up in a the following (wrong) date format = YYY-MM-DD.


For usability reason, it would be nice, if it shows up the right way

Category: Geographies and Localization