the long way
copy ...paste special ....formats

the short way
click onto the cell
click onto copy painter
click onto the new cell

when you double click onto the format painter you can
copy the format onto several individual cells

copy painter is the yellow paint brush in the menu bar with
the copy, paste, and scissors icons.


--
bill k


------------------------------------------------------------------------
bill k's Profile: http://www.excelforum.com/member.php...nfo&userid=821
View this thread: http://www.excelforum.com/showthread...hreadid=477253