Close but not there yet.

While visually it looks fine, it is because the formats of the cells were copied over as well--which I cannot use.

The solution I need will have the same effect as me copying and pasting the =NOW() column into a Notepad document and the copying and pasting the column from the Notepad document back into excel.