Descargar Complemento Numletras Para Excel 2021 Gratis -
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
Automated Conversion: It adds a custom function, typically =NumLetras(cell), that instantly spells out numbers in Spanish.
Currency Customisation: Users can specify the currency within the formula (e.g., "pesos", "soles", "dollars") to ensure the text output matches their financial needs.
Case Sensitivity: The output can be easily wrapped in standard Excel functions like UPPER() (MAYUSC) to display the written number in all caps. Descargar Complemento Numletras Para Excel 2021 Gratis
VBA Based: Most free versions are built using VBA macros, allowing experienced users to view or modify the underlying code to change linguistic nuances. Installation Guide for Excel 2021
Because this is an external add-in and not part of the standard Microsoft Store, you must follow a manual installation process:
Download & Save: Download the .xlam or .xla file from a trusted source and save it in a permanent folder on your computer. The NumLetras (or NumeroLetras ) add-in for Excel
Enable Add-ins: Open Excel 2021 and navigate to File > Options > Add-ins.
Manage Excel Add-ins: At the bottom, ensure "Excel Add-ins" is selected in the dropdown and click Go.
Browse & Activate: Click Browse, locate your saved file, and ensure its checkbox is ticked in the list. Critical Security Considerations complemento NumLetras , - Microsoft Q&A Uso básico
Uso básico
- Escribe en una celda: =NumLetras(A1) — donde A1 contiene el número.
- Para moneda: =NumLetras(A1;"PESOS") o según la variante que incluya el complemento (revisar documentación incluida).
Error "No se puede ejecutar la macro"
- Causa: Archivo bloqueado por Windows o macros deshabilitadas.
- Solución: Ve a Archivo > Opciones > Centro de confianza > Configuración de macros > Habilitar todas las macros (con precaución) y también marcar "Confiar en el modelo de objetos de VBA".
Ejemplo para factura:
Supón que quieres escribir "Se recibió la cantidad de $1,234.56 M.N.".
En Excel:
- Celda B1:
1234.56 - Celda B2:
=Numletras(B1, "Pesos", "Centavos") - Resultado en B2: "mil doscientos treinta y cuatro Pesos 56/100 Centavos"
The Good (What works)
- Free of cost: No subscription or one-time payment required.
- Localized logic: Specifically designed for Spanish speakers (Mexico, Spain, Colombia, etc.), handling currency formats, decimals, and gender agreement (e.g., un millón vs una millón).
- Basic functionality: For simple invoices or checks, it usually gets the job done.
Cómo usar Numletras en Excel 2021: Ejemplos prácticos
Una vez instalado, el uso es increíblemente sencillo.