The NumLetras (or NumeroLetras) add-in for Excel 2021 is a popular third-party tool designed to automatically convert numerical values into text (Spanish words), which is particularly useful for generating invoices or legal documents. Core Functionality & Performance
Abrir Excel: Ve a la pestaña Archivo y selecciona Opciones. Descargar Complemento Numletras Para Excel 2021 Gratis
Versatilidad: Configurable para diferentes monedas (pesos, dólares, soles, etc.). 📥 Cómo Descargar e Instalar Numletras (Paso a Paso) The NumLetras (or NumeroLetras ) add-in for Excel
¡Listo! El complemento estará cargado. Lo verás como una nueva función llamada =NumLetras(). The Solution: The function =LETRA
The "NumLetras" add-in for Excel 2021 is a specialized tool used to automatically convert numeric values into their written word equivalent in Spanish, which is particularly useful for formal accounting, invoicing, and legal documentation Microsoft Learn How to Get the Add-in
: Instantly transforms any number into text using custom functions like =NUMEROS_A_LETRAS(cell) Currency Customization
=LETRA.DE.CELDA() (or SPELLNUMBER in English) was eventually added to Excel.LET and LAMBDA functions in 2021 which allow you to build your own custom formula without VBA, there is still no single native Spanish "Number to Text" button inside standard Excel 2021 (unlike the English SPELLNUMBER found in some Office 365 builds).Function NumLetras(ByVal MyNumber, Optional Moneda As String = "", Optional Centavos As String = "")
Dim Units As String, Tens As String, Hundreds As String
Dim DecimalPart As String
Dim i As Integer
Dim Temp As String
Dim Result As String
' Limpiar formato
MyNumber = Trim(Replace(MyNumber, ",", ""))
If InStr(MyNumber, ".") > 0 Then
DecimalPart = Mid(MyNumber, InStr(MyNumber, ".") + 1)
If Len(DecimalPart) > 2 Then DecimalPart = Left(DecimalPart, 2)
MyNumber = Left(MyNumber, InStr(MyNumber, ".") - 1)
End If
Trabajando...
😀
😂
🥰
😘
🤢
😎
😞
😡
👍
👎
☕