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
G

Guest

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!
 
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"
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to write a number in words in excel worksheet? 2
Convert Numbers to Text 2
Sum cells that have both alpha and numbers 3
from a cell which has numbers how to get it spelled 2
EXCEL FUNCTIONS 1
How to convert Arabic number to english text (63 to SIXTY THREE) 6
Autofill alphanumeric prefix in Excel 2
Alphanumeric Sorting - numeric alpha numeric 2

Back
Top