MY SHEET AT EXCEL ARE NOT LET ME TO CONFIGURE FOR DATE

%3CLINGO-SUB%20id%3D%22lingo-sub-271200%22%20slang%3D%22en-US%22%3EMY%20SHEET%20AT%20EXCEL%20ARE%20NOT%20LET%20ME%20TO%20CONFIGURE%20FOR%20DATE%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-271200%22%20slang%3D%22en-US%22%3E%3CP%3ESee%20the%20image%20bellow.%3C%2FP%3E%3CP%3EThis%20table%20was%20working%20correct%2C%20but%20some%20how%20it%20changed%20alone%20and%20the%20cell%20is%20not%20showing%20the%20same%20is%20at%20the%20%3CEM%3Efx%20field%3C%2FEM%3E%26nbsp%3B.%26nbsp%3B%3C%2FP%3E%3CP%3EAnybody%20can%20tell%20me%20how%20I%20solve%20this.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETks%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F56366iAB947F1104038473%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Screen%20Shot%202018-10-14%20at%2014.34.38.png%22%20title%3D%22Screen%20Shot%202018-10-14%20at%2014.34.38.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-271200%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-276709%22%20slang%3D%22en-US%22%3ERe%3A%20MY%20SHEET%20AT%20EXCEL%20ARE%20NOT%20LET%20ME%20TO%20CONFIGURE%20FOR%20DATE%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-276709%22%20slang%3D%22en-US%22%3E%3CP%3ECould%20you%20provide%20a%20workbook%20witch%20contains%20the%20problem%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-276574%22%20slang%3D%22en-US%22%3ERe%3A%20MY%20SHEET%20AT%20EXCEL%20ARE%20NOT%20LET%20ME%20TO%20CONFIGURE%20FOR%20DATE%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-276574%22%20slang%3D%22en-US%22%3E%3CP%3Ewhen%20I%20do%20F2%2C%20it's%20shows%20right%20at%20%22viewer%22%2C%20when%20I%20do%20enter%2C%20come%20back%20to%20same.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-271207%22%20slang%3D%22en-US%22%3ERe%3A%20MY%20SHEET%20AT%20EXCEL%20ARE%20NOT%20LET%20ME%20TO%20CONFIGURE%20FOR%20DATE%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-271207%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETry%20F2%20and%20ENTER.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

See the image bellow.

This table was working correct, but some how it changed alone and the cell is not showing the same is at the fx field . 

Anybody can tell me how I solve this.

 

Tks

Screen Shot 2018-10-14 at 14.34.38.png

3 Replies
Highlighted

Hi

 

Try F2 and ENTER.

 

Highlighted

when I do F2, it's shows right at "viewer", when I do enter, come back to same.

Highlighted

Could you provide a workbook witch contains the problem?