Hi jacskier,

an 85 would be a
3.5. I know how to do this with auto correct.

are you kidding, mate?

pls. use the vlookup-function (or hlookup if you like) to pick the
correct value using your input and a table.

also want to be able to type the numerical grade on the same
worksheet so that auto correct does not change the grade.

This is why you should not use auto correct. ("Congratulations to you
85 - ehhm 3.5 - birthday, dad!")

Also, is there a way to
type a number in one cell and have that same number appear in another
cell at the same time.

if you want to see in B5 what is in A1 then use this formula in B5:
=A1

arno