TIPOS DE VALORES INCORRECTOS

%3CLINGO-SUB%20id%3D%22lingo-sub-1747316%22%20slang%3D%22es-ES%22%3EINCORRECT%20VALUE%20TYPES%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1747316%22%20slang%3D%22es-ES%22%3E%3CP%3EI'm%20doing%20a%20V%2FV%20LOOKER%20in%20excel%2C%20but%20my%20problem%20is%20next%2C%20the%20value%20that%20the%20formula%20takes%20me%2C%20it%20takes%20it%20as%20a%20value%20that's%20not%20that%20of%20the%20cell.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20cell%20has%20this%20value%20(this%20value%20is%20in%20number)%3C%2FP%3E%3CTABLE%20width%3D%22125%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22125%22%3E889698390491%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20when%20you%20make%20the%20formula%20the%20value%20comes%20out%20like%20this%3A%3C%2FP%3E%3CP%3E8.89698E%2B11%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20already%20change%20the%20format%20of%20the%20cell%20I'm%20looking%20for%20the%20value%20to%20number%2C%20to%20custom%2C%20to%20anything%20that%20allows%20me%20not%20to%20go%20%2B11%2C%20and%20yet%20the%20formula%20still%20detects%20that%20the%20value%20to%20look%20for%20is%208.89698E%2B11%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20don't%20know%20how%20to%20fix%20this!!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1747316%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

Estoy haciendo un BUSCARV en excel, pero mi problema es el siguiente, el valor que me toma la formula, lo toma como un valor que no es el de la celda.

 

La celda tiene este valor (este valor esta en numero)

889698390491

 

Pero al hacer la formula el valor sale asi:

8.89698E+11

 

Ya cambie el formato de la celda que estoy buscando el valor a numero, a personalizada, a todo lo que me permita que no salga +11, y aun así la formula sigue detectando que el valor a buscar es 8.89698E+11

 

No se como arreglar esto!!

 

0 Replies