I thought I'd bump this one back up in case anyone has had any more thoughts
on it.. I've got a similar problem but with dates. I'm running a macro to
import some data to two worksheets (one a copy of the other) on the first
sheet it recognises the dates and a formula tells me what the newest date is.
On the other, the dates are not recognised until I do the non-destructive
edit.. All the formats are the same, auto calc is on.. any ideas?