Just to add, if you change the "sending" cell's format, the "receiving" cell's
format won't change.

RagDyeR wrote:
>
> You've got to do it *twice*.
>
> Paste Special - click "Links",
> Right click again - Paste Special - click "Formats".
> --
>
> HTH,
>
> RD
> =====================================================
> Please keep all correspondence within the Group, so all may benefit!
> =====================================================
>
> "cole" <cole@discussions.microsoft.com> wrote in message
> news:BCCA73D3-C39F-4E58-B36D-A0E9F5871AD1@microsoft.com...
> when I copy using the paste links function I lose the format. How do I
> paste
> links and keep the format?

--

Dave Peterson