Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Spellnumber Formula
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Spellnumber Formula
Describe "does not work" for us.
Just so you know, I tried the Spellnumber function (from http://support.microsoft.com/kb/213360 right?) in my Vista system on both XL2003 and XL2007 and it works fine for me. -- Rick (MVP - Excel) "will07" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Spellnumber Formula
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 "Rick Rothstein" wrote: Describe "does not work" for us. Just so you know, I tried the Spellnumber function (from http://support.microsoft.com/kb/213360 right?) in my Vista system on both XL2003 and XL2007 and it works fine for me. -- Rick (MVP - Excel) "will07" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Spellnumber Formula
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Spellnumber Formula
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2007 excel formula spellnumber | Excel Programming | |||
Can I share SpellNumber.xla Module to other excel | Excel Discussion (Misc queries) | |||
Spellnumber - USD/AFa | Excel Discussion (Misc queries) | |||
spellnumber formula in ms excel | Excel Worksheet Functions | |||
how to use spellnumber formula | Excel Worksheet Functions |