Excel 2000 - cell displays formula not value

  Spike26 15:28 01 Feb 2007

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 2007

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 2007

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

Make sure there are no leading spaces.

  hastelloy 18:50 01 Feb 2007

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

  Spike26 11:02 03 Feb 2007

Thanks Marvin42

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

Elsewhere on IDG sites

WPA2 hack: How secure is your Wi-Fi?

Add Depth Of Field to a photo using Tilt Shift Blur in Photoshop

iPhone tips & tricks

Comment afficher des fichiers cachés sur Mac ?