Date into Fractions in Excel 2007

Posted on 2011-05-02
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
    LVL 18

    Expert Comment

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

    Author Comment

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

    Accepted Solution

    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

    perfect works great!

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    A2 = A1 That kind of cell reference is relative.  If you copy it from A2 to B2, then B2 will get this: B2 = B1 That's all fine and good, but if you then insert a new row above row 2, you'll find: A3 = A1 B3 = B1 This is intentional. …
    Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
    This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
    This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

    755 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

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now