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