rng.NumberFormat = "General"

Regards,
Peter T

"Simon" wrote in message
...
Some cells are pasted in from external sources as a date. I used the
record and play option but it didn't pick up how to format cells as
General.

How is this possible?

Thanks