Congrats on the iMac. Not sure if you ever got your answer
but you cannot open a password Excel file in Numbers and
vice versa. It is unfortunate but you will need to use MS
Office to open those files or maybe a product on open
source in the interim.