You could use a macro............

Sub NumFormat()
Dim cel As Range
On Error GoTo endit
For Each cel In Selection
cel.Value = cel.Value * 1
cel.NumberFormat = "0.00" 'your custom format here
Next cel
Exit Sub
endit:
MsgBox "No cells found!"
End Sub


Gord Dibben MS Excel MVP

On Fri, 25 Aug 2006 09:06:03 -0700, Gary T
wrote:

No

I want to paste the NUMBER format ONLY. I don't want the borders, text
style, font etc to paste with it. JUST the NUMBER format. Can this be done?

Regards

"Richard O. Neville" wrote:

Try the Format Painter. You can add the icon to a toolbar by going to
Tools-Customize-Commands tab. Select the Format menu and the Painter will
appear in the right box, from which you can drag it to a toolbar. Click on
the format you want to "paint," then click on the tool, then click on or
drag over the cells you want to "paint" with that format.

"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