Paste Special Question

[Dan]

Suppose I copy a cell and I want to paste its value and its format to another
cell, but NOT the formula. Is there a way to do this with a single copy and a
single paste?

[Trevor Shuttleworth]

No, don't think so. Single copy, yes. But two Paste Specials; one for the
value and one for the format

Regards

Trevor


"Dan" <Dan@discussions.microsoft.com> wrote in message
news:D9DD38E7-1F62-45D5-A33F-E443B993356D@microsoft.com...
> Suppose I copy a cell and I want to paste its value and its format to
> another
> cell, but NOT the formula. Is there a way to do this with a single copy
> and a
> single paste?

[Dan]

OK, thanks. I do this often enough that maybe it's worth a macro.

"Trevor Shuttleworth" wrote:

> No, don't think so. Single copy, yes. But two Paste Specials; one for the
> value and one for the format
>
> Regards
>
> Trevor
>
>
> "Dan" <Dan@discussions.microsoft.com> wrote in message
> news:D9DD38E7-1F62-45D5-A33F-E443B993356D@microsoft.com...
> > Suppose I copy a cell and I want to paste its value and its format to
> > another
> > cell, but NOT the formula. Is there a way to do this with a single copy
> > and a
> > single paste?
>
>
>