Excel numpad problem

So this is the problem:

My numpad does only work as arrow key in excel 2004, while in the spreadsheet, it does work when i have excel calculator on.

The numpad works in excel 2008, but office 2008 doesn't have VBA, so it's basically useless for me to use since I need Data Analysis toolpack in all my work. (I didn't know that before i bought it so it was just a waste of money )

I've using a MacbookPro with external apple keyboard.
I've turned on and off numlock on the MBP, no difference.
Tried different keyboard layouts (normal, extended, other languages etc..)

I've tried with an external numpad too, same problem.

Thanks in advance.