Thread: Excel: I want to assign numeric values to letters in a speradsheet
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Marion Black Marion Black is offline
external usenet poster
  
Posts: 1
Default Excel: I want to assign numeric values to letters in a speradsheet
Hi,
Any help would be very greatfully received!
I am trying to work on a spreadsheet for a staffing rota. Each shift type
has a letter (i.e. E or LS). I need to assign a numeric value to each letter
that represents the number of hours of that shift (i.e. E= 5.5), so that
totals can be calculated more easily...
But I'm stumped! :s
Reply With QuoteReply With Quote