Probably a very simple thing....

[69liz]

Hi,

I have a spreadsheet which is showing the formula instead of the result. The Show Formula view is not ticked on. What else can I have done?

I am on sheet 2 called Results. Sheet 1 is called Quiz. The formula on sheet 2 is only =Quiz!F7.

Thanks for any help as it is very annoying!

 

[Andrew Poulsom]

Make sure that the cell is not formatted as Text. Then press F2 Enter.

 

[matthew230]

Check what format you have the cell as.

Format - Cell - Click 'General' - OK

For some reason, you have to select the cell, place the cursor at the beginning of your text and press Enter.