Could anyone tell me if it is possible to assign a numerical value to a given word in an excel 2003 spreadsheet. I have created a spreadsheet where there are 5 options that can be selected from a drop down menu in a column and I want to know if it is possible to give each of the 5 words a numerical value when selected. i.e. Low = 1, Medium = 2, etc etc.