Formula for a report - text triggers number

I have a column in a report that I want to put a report formula column next to.  The initial column contains text and I want the formula column to put a numeric value based on the text in the first co...