Convert Numbers into Text?

[robgolf]

I would like to take all numbers in column C of my spreadsheet and turn them into text based on the text value I gave each number.

Ex: I would type the number "1" into cell C1 and excel would automatically convert it into the word "New York". If I typed "2" into a cell it would convert in into the text "Chicago".

Thanks so much guys, any help is greatly appreciated!

-Rob

 

[jolivanes]

@ shg

Thank you very much

Regards
John