Insert/ Name/ Define/ put in your name/ refers to/ put in your number.
--
David Biddulph

"Gav" wrote in message
...
How do I give text codes eg. "LC" or "MC" a numeric or dollars value? I
want
the numeric value to be hidden so I am able to insert text codes into
cells
then sum a total at the end of a column and/or the bottom of a row that
displays a numeric total. I will have not more than ten text codes for
each
column.