This is a strange problem I have time after time. I don't know what I'm doing wrong.
The thing is I just type a formula, and when I'm done it keeps showing the formula, not the result or anything. There arn't any faults also.
Though the formula works on other file's and cells. How can I fix this?
Good morning KcA
Go to Tools > Options, View and check that the box marked "Formulas" under Window options is not ticked.
HTH
DominicB
Please familiarise yourself with the rules before posting. You can find them here.
Cant find it. I use Office 2007 and thats a bit different from the old ones. Next to that I'm using a dutch version so I really dont know which tab falls under tools XD there is nothing like it.
I found something else tho, it said: Show formules instead of results. Something like that, I dont have that ticked so that should be good. But I still found it very strange, that it works fine in some cells/sheets but not in this particular cell.
Last edited by KcA; 04-16-2008 at 06:38 AM.
Hi KcA
Is the cell formatted as text? Press Ctrl + 1, and under the Number tab (I know you're not using the English version, but I don't do Dutch, so you'll have to translate), what is selected in the Category box? If text is selected then formulae won't show as such.
HTH
DominicB
In 2007, go to the Office button, Excel Options, Advanced, then scroll down to "Display options for this worksheet:". Make sure the second box is not checked.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks