The formats for Date, Time, and Special can be set to conform to different locales.

1. Select the cells you want to format.
2. On the Format menu, click Cells, and then click the Number tab.
3. In the Category box, click either Date, Time, or Special.
4. In the Locale (location) box, select a locale to see sample formats for that locale in the Type box.
5. Select the desired number format from the Type box.
6. Click OK.