'copy&paste' web tabular data into excel

[GottaRun]

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.

[David Biddulph]

"GottaRun" <[email protected]> wrote in
message news:[email protected]...
>
> 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