Copy the intended cells. Choose paste special and then paste value and number
format (the last option in the list).
--
HTH...

Jim Thomlinson


" wrote:

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,