how can you convert an entry of 1 to first, 2 to second, etc.?
 

I want to have an entry cell where you put numbers in and and output cell
which displays corresponding first, second, third etc

how can you convert an entry of 1 to first, 2 to second, etc.?
 

Create a lookup table like this:

...........J..........K
1.......1........first
2.......2.......second
3.......3.......third
4.......4.......fourth
5.......5.......fifth

A1 = 3

B1 formula:

=VLOOKUP(A1,J1:K5,2)

--
Biff
Microsoft Excel MVP


"Michaeldc" wrote in message
...
I want to have an entry cell where you put numbers in and and output cell
which displays corresponding first, second, third etc