Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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, |
#2
|
|||
|
|||
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, |
#3
|
|||
|
|||
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, |
#4
|
|||
|
|||
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, |
#5
|
|||
|
|||
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, |
#6
|
|||
|
|||
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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I make the scroll bar show the row number? | Excel Discussion (Misc queries) | |||
How do I auto number cells in an Excel template? | Excel Discussion (Misc queries) | |||
Excel should let me circle a cell or number in the spreadsheet fo. | Excel Discussion (Misc queries) | |||
In Excel how can a number automatically display in text form | Excel Worksheet Functions | |||
Does Excel 2000 have a 'datedif' function to calculate the number. | Excel Worksheet Functions |