formula

[John Proud]

Dear all,

When I enter "=A2" for example into a sheet it stayes as =A2 instead of
bringing the data.

Can anyone explain this please?

XP Pro SP2
Excel 2003


John
North Yorkshire UK

 

[Martin P]

My guess is that the cell is formatted as text. Go to Format, Cells, Number.
Under Category click General and then click OK. Then retype =A2. Hopefully
this will fix it.

 

[John Proud]

Well done Martin.

Just when you think you have everything sorted - you learn some more!

Cheers


John