No puedo sumar estos valores en excel | Teknolosys

No puedo sumar estos valores en Excel

Resolviendo problemas en excel

Nos llegó una pregunta en Excel sobre formatos ya que para nuestra estimada amiga Mariela no podía sumar aún cuando ponía la celda en formato número. Esto sucede podría suceder porque proviene de un reporte, se ha copiado de otro archivo en formato texto, entre otros.

Para poder sumar, una de las opciones más fácil (si es que no conoces realizar alguna macro que solucione) sería extraer el último dígito (el cero que hace que el Excel no reconozca que se trata de un número). Para ello usaremos la siguiente función:

IZQUIERDA (CELDA, LARGO( CELDA) -2 ) : Permite extraer desde la izquierda la cantidad de dígitos correspondientes, tal como se muestra la gráfica correspondiente. A partir de ahí se podrá realizar cualquier operación que se requiera.

11 Comments

  • By Keena Leviner, January 21, 2012 @ 8:20 am

    Very excellent visual appeal on this site, I’d rate it 10 10.

  • By red dwarf, February 4, 2012 @ 12:48 am

    We absolutely love your blog and find nearly all of your post’s to be what precisely I’m looking for. can you offer guest writers to write content available for you? I wouldn’t mind writing a post or elaborating on most of the subjects you write with regards to here. Again, awesome blog!

  • By tknsys, February 15, 2012 @ 11:25 pm

    Thank you for your message 🙂

  • By Flannan, March 14, 2012 @ 1:31 pm

    I just hope to notify you that I am fairly new to blogging and truly savored you might be web site. Doubtless I’m likely to bookmark your web site . You definitely include marvelous articles or blog posts. Thank you a bunch for sharing with us your webpage.

  • By tknsys, March 16, 2012 @ 10:19 pm

    Thanks for your comment, i will improve our content

  • By kore, April 25, 2012 @ 1:44 am

    Hello admin great put up a lot thanks loved this webpage really a lot

  • By fondant garden, June 30, 2012 @ 9:02 pm

    Superb publish admin thank you. I observed what i was trying to find here. I will review whole of posts in this time of day

  • By fondant garden, July 1, 2012 @ 3:32 pm

    Greetings thanks for wonderful publish i was looking for this challenge last 2 times. I’ll search for future valuable posts. Have fun admin.

  • By korea, July 22, 2012 @ 3:08 am

    Hello admin beneficial put up considerably thanks liked this webpage definitely very much

  • By Sonny Disano, October 24, 2012 @ 2:54 pm

    I simply want to mention I am just newbie to weblog and actually savored your web page. Probably I’m planning to bookmark your blog . You surely come with terrific articles. Regards for sharing with us your website.

Posts relacionados

  1. Bitacoras.com — September 13, 2011 @ 11:29 pm

Deja un comentario

Tema