Format cells using a different locale
The formats for Date, Time, and Special can be set to conform to different locales.
- Select the cells you want to format.
- On the Format menu, click Cells, and then click the Number tab.
- In the Category box, click either Date, Time, or Special.
- In the Locale (location) box, select a locale to see sample formats for that locale in the Type box.
- Select the desired number format from the Type box.
- Click OK.