Hi Bernd P,

thanks for the help, I have fixed the issue, The user had not done what he
was told. the solution was that the macro was not allowed to run, even
though the user was told to change the Macro security, he did not do it.

Thanks for the help. Until next time

"Bernd P" wrote:

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