If you format the colums (or individual cell) to "text", you can enter a
fraction, if you just need it to "look" like a fraction.

If you format it to "fraction", it will be a numeric fraction. You can
format adjacent cells and perform math functions to the fraction columns,
like . . .


.. 1ST 2ND TOTAL
1/4 1/16 5/16










rcsw wrote:
Has anyone found a solution to this. This feature is annoying and wastes a
huge amount of time for somthing as simple as copying a table.

Pre-formating only works if you are entering the data by hand or macro, what
if you are pasting a table from word that has fractions, it doesn't matter
[quoted text clipped - 23 lines]

http://www.microsoft.com/office/comm...lic.excel.misc

--
Message posted via http://www.officekb.com