If you are using the TEXT worksheet function because it is part of a larger formula, then you can instruct the function itself to use a different language for its output. Excel modifies the date formats available to you. In the case of Mikael's need, picking English (United States) is a good choice. Using the Locale drop-down list, choose a country or region that uses the date format you want to use.The Number tab of the Format Cells dialog box.

Click Date at the left side of the dialog box.

Excel displays the Format Cells dialog box.

Select the cell (or cells) you want to format.

You can easily format a cell to display a date in any language follow these steps: The first is applicable if you simply need to display a date (and nothing else) in a cell-simply don't use the TEXT function.

There are a couple of ways you can approach this problem. He would like the months returned in English instead, and wonders how he can instruct the TEXT function as to which language it should use. If he uses the TEXT function to format dates, as in TEXT(A1,'mmmm, yyyy'), the textual format returned shows the months in Danish.

Change language in excel