View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Johnny D[_2_] Johnny D[_2_] is offline
external usenet poster
 
Posts: 1
Default Assigning a numeric value to a alpha character

I have created an Employees Absentee Grid to keep up with days missed.
I.e."V" stands for a whole vacation day missed, which equals "1" whole day
missed. And i want to assign "HD" to stand for ".5" day missed. Formula,
PLEASE???????