Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why this date result?
Hopefully self-explanatory illustration:
https://dl.dropboxusercontent.com/u/...Variations.jpg -- Terry, East Grinstead, UK |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Result Based on Date Criteria | Excel Discussion (Misc queries) | |||
Can Excel add working days to a date to result in another date? | Excel Worksheet Functions | |||
Translate WEEKNUM result into a date | Excel Worksheet Functions | |||
fixing the result of a formula after a certain date | Excel Programming | |||
Sum formula result expressed as a date | Excel Discussion (Misc queries) |