View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sross002 sross002 is offline
external usenet poster
 
Posts: 29
Default Convert a letter to a number

Here's how my graph is
a b c d e
1 L L L
2 L L L L
3 L L
4 L L L
5 L
6 30 20 20 30 30

How do I get the L's to represent $10.00 but still have the L in the graph
then when I add them i show the L's added up as numbers?

Basically, what formula will help me get the added sums of L's in numerical
form like in row 6 in my graph?