That is about all I can say. When *I* use YYYYMMDD:HHMM, it just
doesn't work for me. I am using Excel 2000. Maybe a reinstall is needed?
But when I used yyyymmdd:hhmm, it does work! What is the difference? I am
at a loss here. I do have two addins for Excel, one is a unit converter
(convert sizes/amounts to other sizes, such as kilometers to miles), and the
other addin is the ASAP Utilities. Could one (or both) be preventing the
"YYYYMMDD:HHMM" from working?
I am perfectly happy to use yyyymmdd:hhmm, just don't understand why the
capitalized version of that didn't work?