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?.


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