Use the formula =4-{cell containing original number}

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2005

In article ,
says...
how do I recode the negatively coded questions on a likert scale?

where 0=4, 1=3, 3=1, 4=0