ExcelBanter - Why this date result?

Terry Pinnell wrote:

Hopefully self-explanatory illustration:

https://dl.dropboxusercontent.com/u/...Variations.jpg

Now sorted.

I tried to avoid getting into potentially confusing details, but in case
anyone is curious: the window showing '20010709' was actually displayed
by a script I'd written with my macro-writing app, Macro Express Pro. It
operates on two worksheets, successively copying some 40 cells from one
sheet to the other (because my VBA skills are now negligible). It works
perfectly, albeit glacially slowly, on all cells ... except B6. I was so
focused on the fact that this cell was a date (with its potential
formatting issues) that I didn't look harder enough at other
alternatives. When I did, I discovered that, for just that cell, my
script had failed to change focus from the destination sheet back to the
source sheet. So '20010709' is the content of B6 in the destination!

--
Terry, East Grinstead, UK