Datofelter i Excel-ark oprettet på Windows pc, vises i forkert format i OneDrive på iPhone

Question

Datofelter i Excel-ark oprettet på Windows pc, vises i forkert format i OneDrive på iPhone

Vagn 0

Når jeg i OneDrive på iPhone åbner Excel-ark som er oprettet på Windows pc, vises

datofelter i forkert format.

På Windows vises datofelter som dd/mm/åååå, men på iPhone som mm/dd/åååå.

Både min Microsoft konto og OneDrive konto er indstillet til Danmark og dansk sprog. Er

der andre steder jeg kan indstille dato-formatet?

Mvh Vagn

0 kommentarer

1 svar

Dit svar

Answer 1

Jeronimo Fuerte 46,645 Uafhængig rådgiver

Hi, the date display may be coming from the iPhone/iOS regional settings or from the way Excel/OneDrive is rendering the workbook on iOS, even if your Microsoft and OneDrive accounts are set to Denmark. Since the file shows dd/mm/yyyy on Windows but mm/dd/yyyy on iPhone, please first check iPhone Settings > General > Language & Region and confirm that Region is set to Denmark.

In the workbook, you can also try selecting the date cells on the Windows PC and applying a fixed/custom date format such as dd/mm/yyyy instead of a region-dependent date format. Microsoft notes that Excel date formats can depend on regional settings, while custom date formats can be used when you want a specific display format.
https://support.microsoft.com/Excel/format-a-date-the-way-you-want-in-excel

Vagn 0 Omdømmepoint

2026-06-14T10:48:50.86+00:00

Thanks a lot for your reply. I might not have specified that the problem is in the OneDrive preview. If I open the Excel sheet in the Excel app on iPhone/iPad, the date field shows correctly as dd/mm/yyyy. But in OneDrive preview, it shows as mm/dd/yyyy.

And there’s a similar problem with editing amounts. In Denmark, we use a comma as the decimal point and a dot as the thousand separator: 1.000,50. But in OneDrive Preview, it’s shown the other way around: 1,000.50.

My iPhone Settings > General > Language & Region is both language = Danish, and region = Denmark.

Thanks a lot for your effort - it's appreciated.