in excel how do I show a number as an alpha eg 65 as sixty five?
 

in excel how do I show a number as an alpha eg 65 as sixty five?

Thanks,

http://support.microsoft.com/default...;EN-US;q213360

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Changing numbers to Alpha in Excel" <Changing numbers to Alpha in
wrote in message
...
in excel how do I show a number as an alpha eg 65 as sixty five?

Thanks,

Hi, this looked like it would work but the function doesn't seem to be
available on windows xp. Is there a similar function on XP which will do the
same thing? Thanks for your help!

"Changing numbers to Alpha in Excel" wrote:

in excel how do I show a number as an alpha eg 65 as sixty five?

Thanks,

Just follow the instructions in

How to Create the Sample Function Called SpellNumber

But of course don't type the code, but copy it from the instructions and
paste it into
--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
the module.


"Changing numbers to Alpha in Excel"
ft.com wrote in message
...
Hi, this looked like it would work but the function doesn't seem to be
available on windows xp. Is there a similar function on XP which will do
the
same thing? Thanks for your help!

"Changing numbers to Alpha in Excel" wrote:

in excel how do I show a number as an alpha eg 65 as sixty five?

Thanks,

Any way to do it without using VB?!

"Niek Otten" wrote:

Just follow the instructions in

How to Create the Sample Function Called SpellNumber

But of course don't type the code, but copy it from the instructions and
paste it into
--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
the module.


"Changing numbers to Alpha in Excel"
ft.com wrote in message
...
Hi, this looked like it would work but the function doesn't seem to be
available on windows xp. Is there a similar function on XP which will do
the
same thing? Thanks for your help!

"Changing numbers to Alpha in Excel" wrote:

in excel how do I show a number as an alpha eg 65 as sixty five?

Thanks,

Not really.
But if you have a limited number of possible numbers, you could set up a
table with those numbers and the text and use VLOOKUP() or INDEX().

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Changing numbers to Alpha in Excel"
ft.com wrote in message
...
Any way to do it without using VB?!

"Niek Otten" wrote:

Just follow the instructions in

How to Create the Sample Function Called SpellNumber

But of course don't type the code, but copy it from the instructions and
paste it into
--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
the module.


"Changing numbers to Alpha in Excel"
ft.com wrote in
message
...
Hi, this looked like it would work but the function doesn't seem to be
available on windows xp. Is there a similar function on XP which will
do
the
same thing? Thanks for your help!

"Changing numbers to Alpha in Excel" wrote:

in excel how do I show a number as an alpha eg 65 as sixty five?

Thanks,