pre-format as fraction.

--
Don Guillett
SalesAid Software

"James Jensen" <James wrote in message
...
Every time I enter a fraction into a cell, Excel automatically converts it
into a date. This is a pain when I am trying to paste a table with
fractions,
because I have to go back and manually enter them all.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

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