Paste Values and Formats Only????
 

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,

Paste Values and Formats Only????
 

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,

Paste Values and Formats Only????
 

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,