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

  • Thread starter Thread starter Guest
  • Start date Start date
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!
 
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"
 
Any way to do it without using VB?!

Niek Otten said:
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"
Click to expand...
 
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"
 
Back
Top