preserving cell format

How can I preserve a cell format - eg 10 bold font - when pasting in from another cell that is 16 bold font, please?

edit>paste special>format

--
Don Guillett
SalesAid Software
[email protected]
"bob777" <[email protected]> wrote in
message news:[email protected]...
>
> How can I preserve a cell format - eg 10 bold font - when pasting in
> from another cell that is 16 bold font, please?
>
>
> --
> bob777
> ------------------------------------------------------------------------
> bob777's Profile:
http://www.excelforum.com/member.php...o&userid=28504
> View this thread: http://www.excelforum.com/showthread...hreadid=481842
>

thanks for trying to help, but edit, paste special, format does not work - the format changes to that of the pasted cell.