Hi there,
I'm on a Mac, using Excel 2011. After using the subtotal feature I'm copying two columns of results into another worksheet using the F5>special . . . set of steps. Works great. Then I have yet another worksheet that has vlookups with matching values as those in a column in my results page. Problem is that even though they look identical, excel doesn't recognize the cell contents in my copied results as being the same "number" as those the vlookups are referencing (I'm getting #n/a). If I literally retype the exact same number into the cell, it is then recognized fine by the vlookup formula.
I'm guessing that there must be some simple way to tell excel to recognize the pasted cell contents as numbers in the same way it does the vlookup cells. Can anyone help? These are examples of the numbers I'm using. They are formatted as "number" in each sheet.
Thanks in advance -Christine
Project Number
11-GLUT-5484
12-ASF-6515
12-CASC-6461
I'm on a Mac, using Excel 2011. After using the subtotal feature I'm copying two columns of results into another worksheet using the F5>special . . . set of steps. Works great. Then I have yet another worksheet that has vlookups with matching values as those in a column in my results page. Problem is that even though they look identical, excel doesn't recognize the cell contents in my copied results as being the same "number" as those the vlookups are referencing (I'm getting #n/a). If I literally retype the exact same number into the cell, it is then recognized fine by the vlookup formula.
I'm guessing that there must be some simple way to tell excel to recognize the pasted cell contents as numbers in the same way it does the vlookup cells. Can anyone help? These are examples of the numbers I'm using. They are formatted as "number" in each sheet.
Thanks in advance -Christine
Project Number
11-GLUT-5484
12-ASF-6515
12-CASC-6461
