Hi everyone ,i got a problem here.

I want to get a portion of a string ,so i use mid() fucntion,but
after i entered =mid(m2,2,2) , the function doesn't calculate,it just
sit there appear as "=mid(m2,2,2)" .

I checked tools-options and find "auto calculate" is checked, can
anyone give me some suggestion to solve this problem? Thanks!!

I'm using excel 2003 chinese version, operating system is winXP sp2.
And i installed office 2003 sp2.