I think a lookup table or a calculation would work better than autocorrect.

also it would be possible to have one column for number grade
a second column to convert to the GPA
in the Gpa column you could have something like
=vlookup(Num,lookuptable,2)

to have an entry show in a second cell
in the second cell enter
=if(firstcell="","",first cell)
this makes the second cell be blank until something is entered in the first
cell.





"jacskier" wrote:

I am a high school guidance counselor and I am designing a worksheet that
will calculate GPA's for high school students. I need to type the student's
grade for a course in a column and have it change to the equivalent grade on
the 4.0 scale, for example, an 85 would be a 3.5. I know how to do this with
auto correct. The problem is that I also want to be able to type the
numerical grade on the same worksheet so that auto correct does not change
the grade. I need to have the numerical grade on the worksheet also. Is
there a way to shut auto correct off just in one column. 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.