Hi Jennifer,
Did you receive the file as an .xls file or with a different extension.

Can you enter the formula in another column and have it work there
Check the format of the cell with the formula
select cell, format, cells, then is it General or at least something other than Text

Try each of the things already suggested again that you already tried, because I don't think they
will flag the file as needing to be saved.
Tools, Options, Calculation, automatic
Tools, options, View, uncheck Formulas (for viewing formulas)
select the column, Format, cells, General

Change the formula on the formula bar after hitting F2, make sure there
are no spaces to left or right of formula then hit Enter.
If that fixes it then you might fix entire columns using the TrimALL macro
http://www.mvps.org/dmcritchie/excel/join.htm#trimall

Check the title bar for the word [shared] if you see that, then see
http://www.mvps.org/dmcritchie/excel/hilight.htm

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Jennifer H" wrote in message ...
Tried that yesterday, didn't do anything. Thanks for your help, though! Any
other ideas?