Hello,

Did you accidentally hit CTRL + "`" (which would show formulas instead
of values for all cells)? If yes, press that again.

Or is your Excel 2007 cells formatted as text? Then apply format
"General" for that cell, for example, select that cell and press F2
and ENTER.

BTW: If your version of SpellNumber returns the result "Hundred
Fifteen Dollars and No Cents" for the input 1000000000000000 and the
result "One Dollar and No Cents" for the input -1 you might want to
consider using my UDF:
http://sulprobil.com/html/spellnumber.html

Regards,
Bernd

Excel 2007, UK keyboard