pasting time from html

Giganews Newsgroups
Subject: pasting time from html
Posted by:  DJH (dherm…@aol.com)
Date: Thu, 16 Dec 2010

I am copying invoice data from HTML that I am pasting into excel.  I
have multiple fields measured in hours/minutes/seconds.  As an
example,

I copied the number 212:00:00.  When I paste it into excel it is
recognized as 1/8/1900 8:00:00 PM.  I want it recognized as
212:00:00.  What are my options to convert?

Replies