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,

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,

hi
depends. if your talking number formats only and not all formats.
otherwise it would take 2 pastes.
editpastespecialvalues
and
editpastespecialfomats

or
editpastespecialvalues and number formats.(not text formats.)

regards
FSt1

" 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,