View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
tomfernandez1
 
Posts: n/a
Default Converting A Number To Text


Greetings!

I'm stumped on converting a number to text; that is, how can I get cell
A2 to display "apple" when A1 has "1" entered? Or, if I enter "2" in
A1, I want A2 to display "peach."

Any help would be greatly appreciated!

Thank you,

Tommy


--
tomfernandez1
------------------------------------------------------------------------
tomfernandez1's Profile: http://www.excelforum.com/member.php...o&userid=33518
View this thread: http://www.excelforum.com/showthread...hreadid=533072