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

[Guest]

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

Thanks,

 

[Niek Otten]

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q213360

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Changing numbers to Alpha in Excel" <Changing numbers to Alpha in
(e-mail address removed)> wrote in message
news:[email protected]...

 

[Guest]

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!

 

[Niek Otten]

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"

 

[Guest]

Any way to do it without using VB?!

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"

 

[Niek Otten]

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"