Displaying text but the cell needs a numeric value??

  • Thread starter Thread starter RecoilUK
  • Start date Start date
R

RecoilUK

Hi guys

I,m trying to design a rota for work and have very little exce
knowledge, so I hope you can help.

What I want to do is the following.....

The Rota has a key which describes the different shifts etc

Evening 4pm - 10pm

Afternoon 2pm - 10pm

What I want is to display the key as

"E" for the evening shift but have an underlying value of 6 to use i
equations.

Then I could copy this to every evening shift slot.

I hope that makes sense to someone, and I hope you can help.

Thank
 
Back
Top