Hi -
I tried both the solutions suggested by both Frank Kabel and Peo Sjoblom and
they both worked.
I opted for the solution suggested by Frank. With Peo's solution, when I
did the change the time settings, did the conversion and that worked, but
then, since I was not sure, but didn't think I wanted to keep the time
setting change, as soon as I changed it back, the table reverted to having
the "12:XX:XX AM" problem.
Thanks for all the posts from a neophyte Excel user. I was pulling my hair
out last night, and you certainly solved the problem for me.
Jack Cutrone
|