Date into Fractions in Excel 2007

Posted on 2011-05-02
Medium Priority
Last Modified: 2012-05-11
I have a pdf which i right-click the table and choose "open table in spreadsheet" option.  This then shows my values in excel.  However all of my fracations are turned into dates.  How do i keep the fractions from changing into dates?  

I've tried formating the cells to show as fraction however it just shows me a whole number.  
Question by:ansonindustries
  • 2
  • 2
LVL 19

Expert Comment

by:Raheman M. Abdul
ID: 35506680
Select the cells -> Right click ->format cells -> Numeric

Author Comment

ID: 35506730
that does not solve my problem,  i need to show the values as fractions just like in the pdf.
LVL 19

Accepted Solution

Raheman M. Abdul earned 2000 total points
ID: 35506791
Sorry Ignore my earlier comment

Instead of choosing open in spreadsheet
clicking "Copy as Table"   and Open excel and Paste
It works for me

Author Closing Comment

ID: 35507251
perfect works great!

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question