When I bring data from Access (or other databases sometimes) to Excel the numbers do not calculate. It is almost like the numbers are not recognized. I've tried changing the number format but that doesnt work. The only thing that works, which is very cumbersom, is to hit f2 in the cell and then enter. You have to do this for ever cell!

Any ideas?