View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gav Gav is offline
external usenet poster
 
Posts: 5
Default give text a dollar numeric value

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.