Cómo quitar ceros a la izquierda o al final en Excel

Este artículo de wikiHow te enseñará cómo quitar ceros que están al comienzo (a la izquierda) o al final (a la derecha) de los números en Excel.

Método 1

Método 1 de 2:

Quitar ceros a la izquierda

Descargar el PDF

{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/0\/07\/Remove-Leading-or-Trailing-Zeros-in-Excel-Step-1.jpg\/v4-460px-Remove-Leading-or-Trailing-Zeros-in-Excel-Step-1.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/0\/07\/Remove-Leading-or-Trailing-Zeros-in-Excel-Step-1.jpg\/v4-728px-Remove-Leading-or-Trailing-Zeros-in-Excel-Step-1.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Si trabajas con números en una columna, puedes resaltar toda la columna haciendo clic en la letra de la columna.
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/8\/88\/Remove-Leading-or-Trailing-Zeros-in-Excel-Step-2.jpg\/v4-460px-Remove-Leading-or-Trailing-Zeros-in-Excel-Step-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/88\/Remove-Leading-or-Trailing-Zeros-in-Excel-Step-2.jpg\/v4-728px-Remove-Leading-or-Trailing-Zeros-in-Excel-Step-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Si tu computadora no tiene el botón derecho del ratón, presiona Ctrl mientras haces clic con el izquierdo. Aparecerá un menú.
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/b\/bb\/Remove-Leading-or-Trailing-Zeros-in-Excel-Step-3.jpg\/v4-460px-Remove-Leading-or-Trailing-Zeros-in-Excel-Step-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/bb\/Remove-Leading-or-Trailing-Zeros-in-Excel-Step-3.jpg\/v4-728px-Remove-Leading-or-Trailing-Zeros-in-Excel-Step-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Aparecerá el cuadro de diálogo “Formato de celdas”.
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/0\/0d\/Remove-Leading-or-Trailing-Zeros-in-Excel-Step-4.jpg\/v4-460px-Remove-Leading-or-Trailing-Zeros-in-Excel-Step-4.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/0\/0d\/Remove-Leading-or-Trailing-Zeros-in-Excel-Step-4.jpg\/v4-728px-Remove-Leading-or-Trailing-Zeros-in-Excel-Step-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/a\/ae\/Remove-Leading-or-Trailing-Zeros-in-Excel-Step-5.jpg\/v4-460px-Remove-Leading-or-Trailing-Zeros-in-Excel-Step-5.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/ae\/Remove-Leading-or-Trailing-Zeros-in-Excel-Step-5.jpg\/v4-728px-Remove-Leading-or-Trailing-Zeros-in-Excel-Step-5.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/2\/2c\/Remove-Leading-or-Trailing-Zeros-in-Excel-Step-6.jpg\/v4-460px-Remove-Leading-or-Trailing-Zeros-in-Excel-Step-6.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/2\/2c\/Remove-Leading-or-Trailing-Zeros-in-Excel-Step-6.jpg\/v4-728px-Remove-Leading-or-Trailing-Zeros-in-Excel-Step-6.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

6
Haz clic en Aceptar . Está en la esquina inferior derecha de la pantalla. Esto te trae de vuelta a la hoja de cálculo, donde ya no debes ver ceros antes de los números.
- Si aún ves ceros a la izquierda, haz doble clic en las celdas, y luego presiona Entrar o Retorno .
Anuncio

Método 2

Método 2 de 2:

Quitar ceros al final

Descargar el PDF

{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/8\/8c\/Remove-Leading-or-Trailing-Zeros-in-Excel-Step-7.jpg\/v4-460px-Remove-Leading-or-Trailing-Zeros-in-Excel-Step-7.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/8c\/Remove-Leading-or-Trailing-Zeros-in-Excel-Step-7.jpg\/v4-728px-Remove-Leading-or-Trailing-Zeros-in-Excel-Step-7.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Si trabajas con números en una columna, puedes resaltar toda la columna haciendo clic en la letra de la columna.
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/d\/dc\/Remove-Leading-or-Trailing-Zeros-in-Excel-Step-8.jpg\/v4-460px-Remove-Leading-or-Trailing-Zeros-in-Excel-Step-8.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/dc\/Remove-Leading-or-Trailing-Zeros-in-Excel-Step-8.jpg\/v4-728px-Remove-Leading-or-Trailing-Zeros-in-Excel-Step-8.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Si tu computadora no tiene el botón derecho del ratón, presiona Ctrl mientras haces clic con el izquierdo. Aparecerá un menú.
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/e\/e7\/Remove-Leading-or-Trailing-Zeros-in-Excel-Step-9.jpg\/v4-460px-Remove-Leading-or-Trailing-Zeros-in-Excel-Step-9.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/e7\/Remove-Leading-or-Trailing-Zeros-in-Excel-Step-9.jpg\/v4-728px-Remove-Leading-or-Trailing-Zeros-in-Excel-Step-9.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Aparecerá el cuadro de diálogo “Formato de celdas”.
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/5\/59\/Remove-Leading-or-Trailing-Zeros-in-Excel-Step-10.jpg\/v4-460px-Remove-Leading-or-Trailing-Zeros-in-Excel-Step-10.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/5\/59\/Remove-Leading-or-Trailing-Zeros-in-Excel-Step-10.jpg\/v4-728px-Remove-Leading-or-Trailing-Zeros-in-Excel-Step-10.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/b\/b9\/Remove-Leading-or-Trailing-Zeros-in-Excel-Step-11.jpg\/v4-460px-Remove-Leading-or-Trailing-Zeros-in-Excel-Step-11.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/b9\/Remove-Leading-or-Trailing-Zeros-in-Excel-Step-11.jpg\/v4-728px-Remove-Leading-or-Trailing-Zeros-in-Excel-Step-11.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Si hay algún texto en el recuadro, bórralo ahora. Luego, escribe 0.### en el recuadro.
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/e\/ef\/Remove-Leading-or-Trailing-Zeros-in-Excel-Step-12.jpg\/v4-460px-Remove-Leading-or-Trailing-Zeros-in-Excel-Step-12.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/ef\/Remove-Leading-or-Trailing-Zeros-in-Excel-Step-12.jpg\/v4-728px-Remove-Leading-or-Trailing-Zeros-in-Excel-Step-12.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Ya no verás los ceros innecesarios al final de los números.

Anuncio

Iniciar sesión

Cómo quitar ceros a la izquierda o al final en Excel

Pasos

Quitar ceros a la izquierda

Quitar ceros al final

wikiHows relacionados

Acerca de este wikiHow

¿Te ayudó este artículo?

Artículos relacionados

¡Suscríbete al boletín gratuito de wikiHow!

Síguenos

Compartir

Explore Categories