TEXT in English and Spanish
| English Excel | Spanish Excel | |
|---|---|---|
| Function name | TEXT | TEXTO |
| Syntax | =TEXT(value, format_text) | =TEXTO(value; format_text) |
| Example | =TEXT(A1,"dd/mm/yyyy") | =TEXTO(A1;"dd/mm/aaaa") |
Argument names are shown in English for reference. Spanish examples use the semicolon setting.
What TEXT does
Converts a number or date to text using a format. Example: Shows the date in A1 as day/month/year text.
Semicolons, commas and decimals
Spanish versions of Excel separate arguments with a semicolon or a comma depending on the regional settings of the computer. With semicolons, decimals are written with a comma (3,14). With commas, decimals use a point (3.14). FormulaCheck converts both.
A common mistake
Format codes depend on the language of Excel. In Spanish Excel the year code is aaaa instead of yyyy.
Have a formula to translate or check?
Open FormulaCheckQuestions
Why does my Spanish Excel use semicolons?
Spanish versions of Excel separate arguments with a semicolon or a comma depending on the regional settings of the computer. With semicolons, decimals are written with a comma (3,14). With commas, decimals use a point (3.14). FormulaCheck converts both.
What is a common mistake with TEXT?
Format codes depend on the language of Excel. In Spanish Excel the year code is aaaa instead of yyyy.