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.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

This abstract video touches on division in our technologic world

Best alternatives to iTunes for Mac | Best music players for macOS: Free your music from the…