Hi

It depends whether you want to replace your Yes and No with a number, or
have a separate value column.
For the first, you could use Find/Replace.
For the second, in blank column alongside the data you could use something
like this:
=IF(A1="Yes",1,2)

Hope this helps.
Andy.

"Mike Busch" wrote in message
...
I was going to have form submitted to me from a site. The data comes in the
form of headers representing fields and the answers as number. So if it
was a
yes or no answer, the Yes is represented by a 1 and the no is a 2. Is
there a
formula that would change the number to a word. Thank you in advance.