Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 5th 06, 11:29 PM 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


  #2   Report Post  
Old March 6th 06, 11:54 AM posted to microsoft.public.excel.misc
David Biddulph
 
Posts: n/a
Default 'copy&paste' web tabular data into excel

"GottaRun" wrote in
message ...

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?


Paste Special?
--
David Biddulph




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't get data from a web page to chart in excel. Any solutions? goody444 Excel Discussion (Misc queries) 1 March 1st 06 07:09 AM
Excel: How to choose data on two separate rows in the same column RicardoE Excel Worksheet Functions 2 February 24th 06 01:41 AM
Getting Excel Data from One Sheet to Another.... Robin Excel Discussion (Misc queries) 2 April 21st 05 01:15 PM
How can deleted data reappear in a refreshed pivot table in Excel excel_user123456 Excel Discussion (Misc queries) 3 February 23rd 05 09:34 PM
Pulling data from 1 sheet to another Dave1155 Excel Worksheet Functions 1 January 12th 05 06:55 PM


All times are GMT +1. The time now is 02:44 PM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017