Paste Special Enhancement Request

[jcombe]

I have a cell that contains a formula and formatting. I want to copy
the output from the formula and it's formatting. If I do "Paste
Special" I can choose "Value" to paste the value of the copied cell,
but I cannot copy the format, as the choices are radio buttons and so
mutually exclusive.

It would be nice if these options could be tick boxes, so that more
than one can be selected.

Is this possible/planned?

I am using Office 2003, so it is possible this is implemented in 2007.

 

[Dave Peterson]

But you could do two consecutive paste specials--values followed by format.

 

[jcombe]

But you could do two consecutive paste specials--values followed by format.

Yes you could, but it's not as quick, is it?

 

[Dave Peterson]

Depends when you start timing...

If you're gonna wait until it's incorporated into excel, yours might take longer
<vbg>.