Paste Special Formulas strips formatting and pastes the unformatted results.
Try it with dates and times and you'll get the serial values.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)

"Suzi-Q" wrote in message
...
If Edit, Paste Special values strips the formulas from a range and leaves
the
values, I would expect Edit, Paste Special, Formulas to do the opposite.
But,
it doesn't. So, I have two questions: 1) Is there anyway to copy a range
and
paste just the formulas in the result? 2) What exactly is Edit Paste
Special
Formulas supposed to do? (to me, it looks just like copy, paste but maybe
I'm
missing something) Any assistance would be greatly appreciated...