When I import data into Excel 2003, the numbers need to be reformatted so
that they can be calculated. But when I highlight the range and reformat it
to a number format, it doesn't register the change. I have to click inside
the cell contents (hit F2) for it to 'accept' the new format. This
complicates things when there is a lot of data.

Any ideas? Thanks for any help.