View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
GottaRun
 
Posts: n/a
Default 'copy&paste' web tabular data into excel


Hi All,

I have data that should always be treated as text.
From a web page I 'copy&paste' bunch of rows. Some of the cells
have data that looks like this '23:59' or 24:01' basically mm:ss
format. I'm only interested in this as text. What happens '23:59' is
displayed as is in the excel cell but on the other paste brings it in
as '24:01:00' instead of '24:01'.

I tried pre-defining that column as text but the 'paste' overrides it
and brings it in as some date/time field.

How to overcome this?

Thanks so much.


--
GottaRun
------------------------------------------------------------------------
GottaRun's Profile: http://www.excelforum.com/member.php...o&userid=31297
View this thread: http://www.excelforum.com/showthread...hreadid=519189