Home |
Search |
Today's Posts |
#1
|
|||
|
|||
numbers
I need to know if I can type in a number (6) in a cell and either format the
sell to read (six) or write a formula that will read it in another cell???? |
#2
|
|||
|
|||
-----Original Message----- I need to know if I can type in a number (6) in a cell and either format the sell to read (six) or write a formula that will read it in another cell???? . use a lookup table like.... 1 one 2 two 3 three use vlookup function specifying exact matches only. |
#3
|
|||
|
|||
If numbers are more complex than 1, 2, 3 etc.
http://www.xldynamic.com/source/xld.xlFAQ0004.html Gord Dibben Excel MVP On Wed, 2 Mar 2005 06:55:48 -0800, wrote: -----Original Message----- I need to know if I can type in a number (6) in a cell and either format the sell to read (six) or write a formula that will read it in another cell???? . use a lookup table like.... 1 one 2 two 3 three use vlookup function specifying exact matches only. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
Converting Numbers to Text properly | Excel Discussion (Misc queries) | |||
Sorting when some numbers have a text suffix | Excel Discussion (Misc queries) | |||
Sorting imported "numbers" | Excel Discussion (Misc queries) | |||
finding common numbers in large lists | Excel Worksheet Functions |