Skip navigation

Opening an xls file in Numbers

2054 Views 16 Replies Latest reply: May 1, 2012 10:32 PM by Barry RSS
1 2 Previous Next
gpken Calculating status...
Currently Being Moderated
May 1, 2012 11:29 AM

Numbers does not properly open an XLSX file but MS Excel for Mac does. I can, however, open the file with Preview and it displays properly. The problem appears to just in formatting the colums as the data appears as dates instead of numbers.

iMac, Mac OS X (10.7)
  • Wayne Contello Level 6 Level 6 (12,800 points)
    Currently Being Moderated
    May 1, 2012 12:15 PM (in response to gpken)

    You can change the formatting after importing to Numbers rather than "Automatic" using the cells inspector.

  • Wayne Contello Level 6 Level 6 (12,800 points)
    Currently Being Moderated
    May 1, 2012 12:33 PM (in response to gpken)

    can you post what the data looks like after importing into Numbers?

  • Wayne Contello Level 6 Level 6 (12,800 points)
    Currently Being Moderated
    May 1, 2012 2:08 PM (in response to Wayne Contello)

    My bad on two accounts: 1) please omit the persons name in the data and 2) post the data from Excel

  • Wayne Contello Level 6 Level 6 (12,800 points)
    Currently Being Moderated
    May 1, 2012 2:24 PM (in response to gpken)

    OK. Post raw data if possible.  Copy from email and paste as text in this forum editor.

     

    Also do NOT format the columns for BPM, DIA and SYS as date.  change them to numbers by highlighting those cells then use the cells inspector to change to a Number:

    Screen Shot 2012-05-01 at 4.23.41 PM.png

  • Wayne Contello Level 6 Level 6 (12,800 points)
    Currently Being Moderated
    May 1, 2012 2:41 PM (in response to gpken)

    Ken,

     

    I don't have excel either.  You mentioned excel and left out the details:

    1) you want to use Numbers

    2) you don't have excel

    3) you tried once an a friends computer

     

    Providing a good problem statment and details is important.  Usually we try things before reponding to see if we can figure out what you are asking then we ask questions.

     

    What I want to see is what the actual data looks like before being distorted by conversion to dates.  If you do not want to pursue no problem.  I am just trying to point out that you and I have spent several exchanges without getting anywhere because of imcomplete information.  Not trying to beat you up or point fingers just trying to help you understand how details matter and can speed up or slow down this process.

     

    Your problem is tractable but I still don't kow what the data looks like.  I can guess since you are entering Blood Pressure and Heart rate.   But I cannot get the results with date formatting to match what you are posting.

     

    Post back if you want to understand the problem asn we can continue.

     

    Regards,

    Wayne

  • Wayne Contello Level 6 Level 6 (12,800 points)
    Currently Being Moderated
    May 1, 2012 2:57 PM (in response to gpken)

    No need for excel.  You may email data to the email in my profile.  Again just trying to be helpful not tie your hands or be a pest. 

  • Wayne Contello Level 6 Level 6 (12,800 points)
    Currently Being Moderated
    May 1, 2012 4:52 PM (in response to gpken)

    you click my picture and it is to the right of my name

1 2 Previous Next

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.