Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
'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
Posted to microsoft.public.excel.misc
|
|||
|
|||
'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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't get data from a web page to chart in excel. Any solutions? | Excel Discussion (Misc queries) | |||
Excel: How to choose data on two separate rows in the same column | Excel Worksheet Functions | |||
Getting Excel Data from One Sheet to Another.... | Excel Discussion (Misc queries) | |||
How can deleted data reappear in a refreshed pivot table in Excel | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |