Hi Bryan,

If you format the destination cells as 'fraction' or 'number' before pasting, that should resolve the issue. Both preserve them as values, though you'll tend to lose the fraction formatting with the latter.

AFAIK, the only other way to guarantee that pasted fractions are treated as such is to prefix them with a = or ' before copying & pasting. The former preserves them as values (though you'll tend to lose the fraction formatting) whilst the latter stores them as text.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]