View Single Post
  #5   Report Post  
AMY Z.
 
Posts: n/a
Default

The "Edit-Clear-All-save file" procedure fixed it!
Thank you all for the tips, and taking time to answer my dilemma.
Amy

"Anne Troy" wrote:

Hi, Amy. The cell is formatted as text. Try first formatting the cell as
general. If that doesn't work, select it, and hit Edit--Clear--All and
save the file, then re-enter your formula. Also, note that your formula is
much easier written as =A1+A2
*******************
~Anne Troy

www.OfficeArticles.com


"AMY Z." wrote in message
...
Hi I'm fairly new with functions. I am working with Excel 2003

I wrote a simple function =SUM(A1,A2)
The cell the function is in is cell A3.

What's weird is, the formula is always displayed in the A3 cell. Not in

the
background.
The spreadsheet was started by someone else. Would they have some kind of
format that causes this? I've never had this problem before.

Hope I explained this right.
Thanks for your time
Amy