Excel 2000 - cell displays formula not value

  Spike26 15:28 01 Feb 07
Locked

I'm going crazy!
I've one sheet in my workbook where I've used the wizard to concatinate a number of text cells into a single cell.
That cell will only display the formula although the wizard shows the correct result.
A simple "=a1+b1" displays the formula as does "=1+1".

Other sheets in the same workbook show the formula values correctly.

Can someone tell me what I'm missing please.
Spike 26

  FreeCell 17:34 01 Feb 07

Just a thought. You haven't got a stray apostrophe or some other format character at the beginning of the formulae have you?

  VoG II 17:40 01 Feb 07

Check that the cell's format is set to General.

Make sure there are no leading spaces.

  hastelloy 18:50 01 Feb 07

Under Tools, Options check that Formula isn't ticked.

  Spike26 11:02 03 Feb 07

Thanks Marvin42

This thread is now locked and can not be replied to.

Surface Pro (2017) vs Surface Pro 4

20 groundbreaking 3D animation technologies coming to Siggraph 2017

iPad Pro 12.9 vs Surface Pro 5