Keep to one post, Neik has an answer in the other one.

Steve

On Wed, 04 Oct 2006 13:57:01 +0100, Tina
wrote:

Sometimes the formula displays in the cell instead of the value. How do
I
get the cell to always show the value? I've tried the Ctrl + `
combination
but this doesn't seem to help in some of my spreadsheet. Is this a
setting
I'm missing?

Thanks!!