return alpha equivalent of a number

[UweNaujak]

Hello there:
I have been unsuccessfully checking the Internet to find a solution for this task:
I want to convert a number (1 to 12, it is actually the [Month(date)] function) to its alpha equivalent, i.e.
1 = "One"
2 = "Two", etc.
Is there a function available to do this or do I have to write a VBA Sub, which I have done already? Having a huge accounting application I am trying to minimize code.
Thanks, anxiously awaiting any ideas.
Uwe

 

[JimM]

Probably not the most stylish way but you could use

=CHOOSE(A1,"One","Two","Three","Four","Five","Six","Seven","Eight","Nine","Ten","Eleven","Twelve")

 

[UweNaujak]

Probably not the most stylish way but you could use

=CHOOSE(A1,"One","Two","Three","Four","Five","Six","Seven","Eight","Nine","Ten","Eleven","Twelve")

Thank you Jim, this works perfectly fine for me. I greatly appreciate your advice. Glad to be part of this forum. Have a great day, Uwe