Is there a way to paste the value and formats only from one cell to
another at the same time?

I'm dealing with a fairly large amount of data.

Thanks,