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]

Thanks for the reply, Paul!

Does that mean every time I open a few workbook I have to format the cells as numbers before I start?
Since that seems fairly redundant, I was wondering if I can change the options of the default "New Workbook" to have that done beforehand..

Bryan