Yeah, I can't explain it.
I tried what you said, p45cal--I switched all the dates to general, and indeed some remained just the text of the date while others became numbers (the numbers I can't explain; for example, March 24, 2017 became 42818 <-- Huh!?). But trying to switch them back to date doesn't seem to work. I try all kinds of formats, hoping Excel recognizes at least one, but it doesn't.
Anyway, I'm attaching the file in case anyone wants to take a crack at it.
Thanks very much for trying to help.
|