Excel TEXT Function: How to Use It, with Examples
Turkish: METNEÇEVİR

Converts a number or date to text in the format you want, such as the day name of a date or a number with thousands separators.

TEXT syntax

=TEXT(value, format_text)

In Turkish Excel: =METNEÇEVİR(değer; biçim_metni)

ArgumentDescription
valueNumber or date.
format_textFormat code in quotes.

TEXT examples

=TEXT(DATE(2026,11,12),"dd.mm.yyyy")
Result: 12.11.2026

Converts the date to day.month.year text.

=TEXT(DATE(2026,11,12),"dddd")
Result: Thursday

Returns the weekday name.

Results were calculated in real Excel.

Tips for TEXT

  • Format codes depend on Excel's language: English Excel uses "dd.mm.yyyy", Turkish Excel uses "gg.aa.yyyy". A formula copied between languages must have its codes adjusted.
  • The result is text; use the original cell for date calculations.

Related functions

More formula guides

More tools

About TEXT Function

Converts a number or date to text in the format you want, such as the day name of a date or a number with thousands separators.

Turkish function names were taken directly from Turkish Excel, and the example results on formula pages were calculated in real Excel. Everything runs in your browser; your data is never uploaded.

How to use TEXT Function

  1. Type the formulaStart typing =TEXT( in a cell; Excel shows the arguments.
  2. Fill in the argumentsSeparate them with commas (semicolons in Turkish Excel).
  3. Press EnterCheck the result; you can also try it in the tester below.

Frequently asked questions

What is TEXT in Turkish Excel?

In Turkish Excel, TEXT is called METNEÇEVİR. Turkish Excel also separates arguments with semicolons (;) instead of commas.

Which Excel versions have TEXT?

TEXT is available in all current Excel versions (2010 and later, Microsoft 365).