VBA to Show Cell as Text String but Value as Number

[jmh2008]

Trying to create a sheet for archery scores. If someone hits the Bullseye, it's marked as an "X" but recorded as 10 point.

We need to keep the X's, but this will determine who was the highest score, but if there's a tied, then it's whoever have the most "x's".

How can I Show on the Score sheet the "X", but have the value of 10 so I can sum and average the scores.

Thanks

 

[My Aswer Is This]

Try this for example:
Shows the number of X's in Range("F1:F7")

=COUNTIF(F1:F7,"x")

 

[jmh2008]

Sorry, that wouldn't work is what I have set up. I have VBA working now that when you search for a record it copy from "All Score" to the input sheet. Also, an X and "Hitting the Yellow" are both worth 10 points.

I was hoping to incorporate something into my existing VBA. I'm just not a VBA pro by any means.