Try this line just before you transfer the values...
ActiveCell.NumberFormat = "@"
'--
Your name seems familiar...?
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"Arch Stanton"
wrote in message
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.