Try these two
A) with Format Painter
Select any cell in A1:B2 and click the Format Painter (it looks like a wide
paint brush), now select the range D1:J6 and these all get the format of the
initial cell. You can copy only one format but you can copy it to as many
cells as you wish.
If you want to 'paint' more than one range at a time: double click Format
Painter and paint each range; when done press Esc or click Format Painter
icon.

B) With Paste Special
Select a range of cells have the formats required and Copy.
Move to the first cell in the target range and use Edit | Paste Special -
Format
You can copy more than one format at a time but the target and source ranges
must be the same size.

best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Gary T" wrote in message
...
Is there a command in either:

(i) the Paste ... Special menu; or
(ii) an icon that I can move into the taskbar

that will allow me to Paste number formats only?

I'm using Office 2000.

Regards