Microsoft 365 and Office | Excel | Other | MacOS
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Excel for Mac create wrong format for date type cell by default
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
I create blank file and format a single cell as Date. I type 22.02.2020 and save the file. I change the file extension from .xlsx to .zip, unzip the file, navigate to the "xl" folder and open the "styles.xml" file. "formatCode" is "dd/mm/yyyy;@". When I upload the file to Google sheets, it is recognized as 2/22/2020. In Numbers, Calc, Excel for Windows I'm able to produce correct format following described steps - when I upload the file to Google sheets, it is recognized as 22.02.2020
How to achieve in Excel for Mac that format code is "dd.mm.yyyy;@". How can Excel for Mac create date in dd.mm.yyyy format, 22.02.2020?
My region is Switzerland, Language is Deutsche (Schweiz), date format is dd.mm.yyyy
Microsoft Office Excel for Mac 16.57 (22011101)
macOS Ventura 13.3.1
MacBook Pro 13 inch, M1,2020
Thank you for any kind of help!
Microsoft 365 and Office | Excel | Other | MacOS
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.