There is a table that I am trying to copy into Excel. I am able to select the table and copy it just fine. The problem comes when I try to paste it into excel. The table has fraction, but Microsoft, geniuses that they are, seem to think that it's best to turn fractions into dates (no one could possible actually want fractions could they ). I have tried fiddling with the autoformatting options, setting the cell format (to general, number, text, and fractions) ahead of time, and setting the cell format afterwards. No luck with any of it. Any suggestions?
Oh yeah... and I've done this both on a computer running windows 98SE with Excel 97 and on a computer running windows XP with whatever the most recent version of excel is.
That is a stumper. You can always copy and paste into Word and from there copy and paste special as a Microsoft Word Document object into Excel... but wonder why we can't get the fractions to work. . .
Posts: 9192 | Location: Atlanta, GA, USA | Registered: 06-03-02
Methos what I did to make it work was copy the table from the website on your link to Microsoft Word
The on EVERY FRACTION added 0 (zero) before the fraction IE 0 1/2, I then pasted in to EXCEL and they stayed as a fraction....but with out the zero the converted to a date?...Excel seems to to think a fraction is a part of the year.....prfixing the fraction with a zero elimates this.....I assure you it works I just tried it. Not sure now, but I think I did it this way. ZERO/SPACE/FRACTION....if does not work (try just one fraction first) dont enter the space.
). I have tried fiddling with the autoformatting options, setting the cell format (to general, number, text, and fractions) ahead of time, and setting the cell format afterwards. No luck with any of it. Any suggestions?
