Excel Spellnumber Formula

  • Thread starter Thread starter will07
  • Start date Start date
W

will07

Hi Everybody,
I am using 2003 version excel and have a page set up with a code that lets
me use the formula Spellnumber. The problem is that when a user with Vista
2007 version opens the file up the formula does not work. Any ideas that
will let both Vista and Std Windows users get the same result from the cell.

thanks
 
When a Vista user opens the file, the actual formula will appear instead of
the result. Example - =spellnumber(F97). The code I added was sourced
through the discussion group. I was hoping I could change this code so that
both 2003 and 2007 users would get the same result.

thanks
 
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
 
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
 
Back
Top