Problem Importing Excel Data into Numbers
Hi Everyone,
I am using Numbers to grade classes.
While trying to lear the program in order to create a grade book/attendance spreadsheet, I found the templates.
I am using a variation of the template "Grade Book".
I was able to taylor it to my particular need, which includes having weight course work so that each part is worth a different percentage.
The problem I have is that I need to import grades from an excel spreadsheet and when I copy them, includes the formulas that were in the template before. I tried paste, paste and match style and paste value.
e.g
and this is an example of the data I need to copy into the respective columns, in this case, ELEMENTS And MIDTERM, disregards the 2nd row, that contains the points, I need to copy and paste the percentages and have the spreadsheet calculate total and final grade.
iMac (27-inch, Late 2012), OS X Mavericks (10.9.1)