up vote
-2
down vote
favorite
According to https://support.office.com/en-us/art...ad=US&fromAR=1, the built-in formats starting with an asterisk (*) are regional. They will display different format according to your OS region.

I specify a custom format dd/mm/yyyy hh:mm in a cell, the first weird thing is, Excel treats it as a built-in format, id is 22. According to ISO/IEC 29500-1, Information technology — Document description and processing languages — Office Open XML File Formats — Part 1: Fundamentals and Markup Language Reference, 18.8.30 numFmt (Number Format). ID 22 is m/d/yy h:mm

The 2nd weird thing is, the built-in format which is not regional, also display different formats upon different regions.

under UK
dd/mm/yyyy hh:mm

under TW
m/d/yy h:mm

enter image description here

The only explanation I found is in 18.8.30 numFmt (Number Format),
... Some of these Ids can be interpreted differently, depending on the UI language of the implementing application.
Does anyone know any document that describe the behavior/specification explicitly?