I'm trying to paste concatenated values to cells on a spreadsheet using
this formula:

ActiveCell.Value = ActiveCell.Offset(0, 5).Value & " - " &
ActiveCell.Offset(0, 6).Value

But when a concatenated value that looks like a date gets pasted into a
cell, the cell turns it into a date. For instance, if my formula pastes
"4 - 72" into a cell, Excel changes it into Apr-4. I've tried turning
the values into strings, adding spaces, etc., but Excel always turns my
pasted values into dates.

I feel like a dolt for asking this, and I've been through the help
utility and Googled it, but I just can't work out how to suppress the
autoformat function, or whatever that is.

Thanks for any help.

----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----