"Paste Number Formats only" in Paste Special Submenu
This is totally missing! You can Paste VALUES with Number Formats, or FORMULAS with Number Formats, or ALL Formats including borders, backgrounds and foreground colours, but you CANNOT Paste Number Formats ONLY! Most of my wasted time in Excel is from this tedious task! There should definitely be an option for "Number Formats Only" in the Paste Special Submenu, if not a "Number Format Painter" as well!