Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I turn auto correct on or off for one column only?
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Correct ? | Excel Discussion (Misc queries) | |||
Is it possible to export the (Excel) auto correct "dictionary" to. | Excel Discussion (Misc queries) | |||
auto correct | Excel Discussion (Misc queries) | |||
Export auto correct dictionary | Excel Discussion (Misc queries) | |||
Is there a way to have a function auto correct words in ALL CAPS . | Excel Worksheet Functions |