Dates and times in xl are just formatted numbers. The weird number you
see when you format as general is the actual value that represents the
date/time January 6, 2008 6:00 PM and 30 seconds.

Just format the dates and times the way you want after pasting. You
can use this custom format to make them all appear like your first
example: m/d/yyyy hh:mm:ss AM/PM.

If you change the dates/times to text, you won't be able to calculate
with them or change their appearance except manually.


Cliff Edwards