formula

J

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
 
M

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

John Proud

Well done Martin.

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

Cheers


John
 
Top