Formula excel

1 got problem with my MS Excel worksheet 2007. There are 2 worksheet name worksheet a n worksheet b. 1st worksheet contain name of student and its mark (score). 2nd worksheet contain name of student, mark n letter grade. the problem is when I type the student score in worksheet a, the score and its letter grade show correctly in worksheet b. but when I copy a mark from ms word and paste it in worksheet a the letter gred wrongly show in worksheet b. so I can't copy any number from other worksheet or from ms word. Example, peter got 50 marks for English paper and letter grade show in the worksheet b should be C. if I type 50 the letter grade show correctly in worksheet b. If I copy 50 from other worksheet or ms word and paste it in worksheet a, the letter grade show A in worksheet b. I just can type in worksheet a only, so as the letter grade will show correctly. How to solve this. Can u reply me to my email [email protected] tq
Anonymous User
Anonymous User
Asked Apr 02, 2016

TIP: If it's not your answer to this question, please click "Leave a Comment" button under the question to communicate with the question owner.

Categories