Ok. so I don't know near as much about excel as i thought i did... i KNOW there is so much more i could do with excel but apparently, i'm not even a dilettante.

If you are feeling generous enough to assist, there are 2 questions I would pose, after leading with this info:

The REAL word is PATHFINDER (i was trying to be clever and not give it out, thinking i could easily substitute in the correct code/text but because i am so ignorant of what it is you did there, i cannot do it!) however, PATHFINDER is 1-0, so using your code, the correct "word" as 0 - 9 would be "RPATHFINDE."

Therefore

1) would you be willing to revise the above file so that it uses the correct word

and

2) how the crap do i "use" it in a spreadsheet of my own? The Excel class i took some years back had about a 5 minute section on macros, consisting of, "go to cell A, type xxx, type this, type that, ok there you go - you've written a macro!" Basically, I want to be able to type the coded text in a cell where it displays as that text, but then displays its numerical value in another cell with two decimal places. The cost code is always written to include all digits of a price, dollars and cents, and the code never has decimals. For example, PAFR will mean $12.50 or 12.50 (dollar sign not necessary.)

I appreciate your assistance!

Thanks again,

Alicia