Hi I am a new member and am hoping someone can help me...I have muddled through with an Excel template set up for me by my accountant years ago to do my annual accounts spreadsheets for my tax return (due in 8 days!). I normally create new sheets by using the Move & Copy command and wiping the contents with no problems, and the formulas move too. This time, every time I enter data in the fresh sheet it just disappears whether I press Return or just click another cell. The figures don't show in the Total bar either even though the formula seems to be showing ok in the formula bar.
Even more odd, when I tried clearing contents from an existing sheet and enter new data (without moving or copying anything) the same thing happened. Nothing in the cells!
I have the text colour set to black by the way and format to Number. As you can tell I am a complete beginner so simple answers appreciated!