"GottaRun" wrote in
message ...

Yes, please explain.
format 0 seems to be an option from the custom drop-down list.

My problem is I have mm:ss data that I want treated as text instead of
date/time. Excel insists on appending :00 to any value greater than
23:59.

I tried format 0 both before pasting & after pasting. After pasting,
format 0 changed everything to a 1??

Ideally want I want is to tell excel that all my 'pasted' data should
be treated as text.

What's the secret?.

If you want something formatted as text to stay that way, try Paste Special/
Values
--
David Biddulph