Cell input disappears after enter..

[tommyfernandez]

Greetings,

The strangest thing started happening with my Excel 2010. When I input anything into a cell and hit enter, the input disappears!

Any thoughts on why this his happening?

-Tommy

[Lemice]

Hello,

Are you sure the file is not protected?
Is your background color white? Are you using any macro? Are you sure the cell is totally empty after you hit enter? You can do a simple ISBLANK to check it.
If nothing works, can you provide a sample file?

[FDibbins]

goes it still show up on the status bar?

Is the color set to white?

[tommyfernandez]

The color is not set to white. I can delete cell data, but when I input something and hit enter, or click on a different cell, the input disappears. The worksheet is not protected nor has macros.
-Tommy

[Lemice]

After you hit enter in, say Cell B5, can you put a formula somewhere easy to see in your worksheet like =ISBLANK(B5) and see if it's TRUE?
If it is, can you provide a sample of that file?

[tommyfernandez]

Here is a sample of the workbook.. Thanks for the attention to this matter..

-Tommy

[Lemice]

Weird, I can write anything in any cell in the file, I don't know what's wrong with it ...

[tommyfernandez]

I cannot even try the ISBLANK function since whatever I input disappears then I hit enter or click on another cell...

-Tommy

[tommyfernandez]

Could it be the settings with this workbook? If I open a new workbook there is no issue... Strange!

-Tommy

[Lemice]

I have attached that file with my random input when I faceroll on the keyboard ...
Please see if you can write anything in it now.

P/s: this is a silly suggestion but, did you try Alt-F4 Excel and reopen it?

[tommyfernandez]

I still cannot write to this workbook. Instead, I opened Excel then from there opened the problem workbook and now I can write to it.
I don't know if this is considered "SOLVED"... Again, strange...
Thanks for your time and attention... If you discover any further information, please let me know..

Thanks,

-Tommy