No cambia la formula de la celda de texto a numero

%3CLINGO-SUB%20id%3D%22lingo-sub-2725976%22%20slang%3D%22es-ES%22%3Edoes%20not%20change%20the%20formula%20of%20the%20text%20cell%20to%20number%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2725976%22%20slang%3D%22es-ES%22%3E%3CP%3EIn%20this%20capture%20is%20as%20it%20should%20look%2C%20but%20it%20does%20not%20look%20that%20way%20nor%20does%20it%20allow%20you%20to%20change%20the%20format%20of%20cells%2C%20I%20would%20appreciate%20the%20help!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2725976%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20Scripts%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EUser%20Adoption%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2731789%22%20slang%3D%22en-US%22%3ERe%3A%20No%20cambia%20la%20formula%20de%20la%20celda%20de%20texto%20a%20numero%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2731789%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1148172%22%20target%3D%22_blank%22%3E%40dami130%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CSTRONG%3ESteps%20to%20Turn%20Error%20Checking%20Option%20On%2FOff%3C%2FSTRONG%3E%3C%2FSPAN%3E%3C%2FP%3E%3CUL%3E%3CLI%3EClick%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EFile%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%26gt%3B%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EOptions%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%26gt%3B%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EFormulas%3C%2FSTRONG%3E.%3C%2FLI%3E%3CLI%3EThen%20under%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EError%20Checking%3C%2FSTRONG%3E%2C%20check%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EEnable%20background%20error%20checking%3C%2FSTRONG%3E.%20(%3CSTRONG%3EDoing%20this%20mark%20the%20error%20with%20a%20triangle%20in%20the%20top-left%20corner%20of%20the%20cell.)%3C%2FSTRONG%3E%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Error-Checking-Figure-2%22%20style%3D%22width%3A%20904px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F308907i2F08791FC1DF14E0%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Error-Checking-Figure-2%22%20alt%3D%22Error-Checking-Figure-2%22%20%2F%3E%3C%2FSPAN%3E%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

En esta captura es como se debería ver ,pero no se ve de esa manera ni tampoco permite cambiar el formato de celdas, agradecería la ayuda!

2 Replies

@dami130 

Steps to Turn Error Checking Option On/Off

  • Click File > Options > Formulas.
  • Then under Error Checking, check Enable background error checking. (Doing this mark the error with a triangle in the top-left corner of the cell.)

 

 

Error-Checking-Figure-2

@Juliano-Petrukio  no me estria funcionando,sale esto,lo raro es que en otra pc si aparece lo de la captura anterior,sale lo que esta en la captura que envio