TEXT Function - Microsoft Support

You can alter the way a date displays by using a mix of "M" for month, "D" for days, and "Y" for years.

Month, Day and Year format codes

Format codes in the TEXT function aren't case sensitive, so you can use either "M" or "m", "D" or "d", "Y" or "y".

Excel MVP Mynda Treacy

Mynda Recommends...

If you share Excel files and reports with users from different countries, then you might want to give them a report in their language. Excel MVP, Mynda Treacy has a great solution in this Excel Dates Displayed in Different Languages article. It also includes a sample workbook you can download.

Tag » What Does 0 Mean In Text