I am only a basic Excel user and I am trying to create a spreadsheet to use for an inventory count.

I have a category that is the 4 digit code for the price paid for an item shown in letters (each letter is a different number) i.e. FRED would be $12.45.  I would like to convert the code to the actual price paid on the spreadsheet.  I don’t know if the is possible or not and have not had much luck trying to figure out if it can be done.

​I am only a basic Excel user and I am trying to create a spreadsheet to use for an inventory count.I have a category that is the 4 digit code for the price paid for an item shown in letters (each letter is a different number) i.e. FRED would be $12.45.  I would like to convert the code to the actual price paid on the spreadsheet.  I don’t know if the is possible or not and have not had much luck trying to figure out if it can be done.   Read More

​