Converting a letter to a number
Posted by Mark Taylor on July 05, 2001 6:14 AM
I am putting together a spreadsheet on the absence of members of staff. For information purposes instead of just putting a number for absenties I want to put a letter instead, i.e. 'h' for holiday, 's' for sick etc.
The value of any letter entered will be '1'.
So the line at the end of the workbook that is calculating the total number of days off that someone has had will calculate the letters as '1' etc
Please help asap