Cell referencing

C

CrankyLemming

This is really odd.

I have a worksheet which has several cells with formulae similar to
this:

A1="Total amount payable: £" & Calcs!F1

Every one of these works fine (a1 shows: _Total amount payable:
£100_), except one which actually shows the line quoted above. I've
checked the cell properties and can't see anything amiss.

Does anyone know what's happening?

TIA

Steve
 
F

Frank Kabel

Hi
check the cell format. Probably set to 'Text'.<Change this to 'General'
and re-enter your formula
 
C

CrankyLemming

Frank said:
Hi
check the cell format. Probably set to 'Text'.<Change this to 'General'
and re-enter your formula
Click to expand...

No, I tried that, and they were all set the same. Thanks, though.

I put it right in the end by highlighting the cell above, which had a
similar formula, clicking and holding the little black square in the
corner (don't know the proper term for this), and then overtyping with
what I wanted.

Wierd, though, eh?

S:)
 
D

Dave Peterson

If you changed the format from Text to General, try reentering the formula in
that cell (Hitting F2, then enter with that cell selected is enough).

If that didn't help, do you have a space character before the leading equal
sign.
 
Top