Good Morning, I am using Excel 2003 with Windows XP.

In cell A I have a list of 40 values and I am trying to pull a random
sample. In column B I put Rand() and in Column C I put
=INDEX(A$1:A$200,RANK(B1,B$1:B$200))

I appers to be working in Colulmn C but Column B is displaying a number.
for example A:1 has the letter A in it. Column B has 0314237.

Why is it doing that. Is it something I have done and how do I fix it?

thanks in advance for your help!!