Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
How can I create a function to do this?
A1 1 One A2 2 Two A3 3 Three A4 4 Four A5 5 Five A6 6 Six ....... |
#2
![]() |
|||
|
|||
![]()
Depends on the complexity. If just single digits, use
=CHOOSE(A1,"One","Two","Three","Four","Five","Six" ,"Seven","Eight","Nine") If more complex, see http://www.xldynamic.com/source/xld.xlFAQ0004.html -- HTH Bob Phillips "cradino" wrote in message ... How can I create a function to do this? A1 1 One A2 2 Two A3 3 Three A4 4 Four A5 5 Five A6 6 Six ....... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I convert excel file into ASCII text file with alignment? | Excel Discussion (Misc queries) | |||
convert a range of lowercase text to upper text or vice versa | Excel Worksheet Functions | |||
How to reformat numbers stored as text (apostrophe at beginning) | Excel Discussion (Misc queries) | |||
Sort or Filter option? | Excel Worksheet Functions | |||
Convert text to numbers | Excel Discussion (Misc queries) |