Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste Number Formats
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste Number Formats
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste Number Formats
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste Number Formats
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste Number Formats
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I paste without EXCEL increasing the cell number ? | Excel Worksheet Functions | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
how do I paste links and keep formats | Excel Discussion (Misc queries) | |||
Maximum Number of Cell Formats | Excel Discussion (Misc queries) | |||
Conditional Number Formats | Excel Discussion (Misc queries) |