Cell referencing

[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

 

[Frank Kabel]

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

 

[CrankyLemming]

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

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

 

[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.