Previous 1 2 Next 16 Replies Latest reply: May 1, 2012 10:32 PM by Barry
gpken Level 1 Level 1 (0 points)

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 (16,140 points)

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

  • gpken Level 1 Level 1 (0 points)

    It seems that I can change the format to other date styles but unable to change it to numbers or text. I tried using th Inspector and the format does change somewhat but remains a date. The date BTW is based on days after 1900.

    I suppose that if I fumble around enough I should be able to come up with a solution but what troubles me most is that Preview and MS Excel open it correctly to begin with while Numbers does not.

  • Wayne Contello Level 6 Level 6 (16,140 points)

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

  • gpken Level 1 Level 1 (0 points)

    The first colum "Date" is okay but all other data should be just numbers

     

     

    Kenneth Clunisr

    Measurements from:

    19/04/12

    to:

    25/04/12

     

     

     

     

     

     

    DATE

    SYS

    DIA

    BPM

    Manual entry

    2012-04-19 22:11

    5/25/1900 12:00:00 AM

    3/19/1900 12:00:00 AM

    3/20/1900 12:00:00 AM

     

    2012-04-20 07:04

    5/28/1900 12:00:00 AM

    3/30/1900 12:00:00 AM

    3/10/1900 12:00:00 AM

     

    2012-04-20 15:31

    4/25/1900 12:00:00 AM

    2/26/1900 12:00:00 AM

    3/9/1900 12:00:00 AM

     

    2012-04-20 22:19

    4/22/1900 12:00:00 AM

    3/2/1900 12:00:00 AM

    3/12/1900 12:00:00 AM

     

    2012-04-21 07:26

    5/11/1900 12:00:00 AM

    3/11/1900 12:00:00 AM

    3/1/1900 12:00:00 AM

     

    2012-04-21 15:05

    4/26/1900 12:00:00 AM

    3/6/1900 12:00:00 AM

    3/8/1900 12:00:00 AM

     

    2012-04-21 22:14

    5/5/1900 12:00:00 AM

    3/6/1900 12:00:00 AM

    3/2/1900 12:00:00 AM

     

    2012-04-22 06:31

    5/27/1900 12:00:00 AM

    3/16/1900 12:00:00 AM

    3/1/1900 12:00:00 AM

     

    2012-04-22 06:36

    5/31/1900 12:00:00 AM

    3/20/1900 12:00:00 AM

    3/4/1900 12:00:00 AM

     

    2012-04-22 16:19

    5/16/1900 12:00:00 AM

    3/12/1900 12:00:00 AM

    3/5/1900 12:00:00 AM

     

    2012-04-22 21:12

    5/2/1900 12:00:00 AM

    3/5/1900 12:00:00 AM

    3/7/1900 12:00:00 AM

     

    2012-04-23 06:29

    6/9/1900 12:00:00 AM

    3/23/1900 12:00:00 AM

    3/4/1900 12:00:00 AM

     

    2012-04-23 13:23

    5/21/1900 12:00:00 AM

    3/7/1900 12:00:00 AM

    3/8/1900 12:00:00 AM

     

    2012-04-23 21:31

    6/8/1900 12:00:00 AM

    3/20/1900 12:00:00 AM

    3/7/1900 12:00:00 AM

     

    2012-04-24 06:05

    6/27/1900 12:00:00 AM

    4/14/1900 12:00:00 AM

    3/9/1900 12:00:00 AM

     

    2012-04-24 07:44

    6/18/1900 12:00:00 AM

    3/30/1900 12:00:00 AM

    3/8/1900 12:00:00 AM

     

    2012-04-24 07:46

    6/18/1900 12:00:00 AM

    3/24/1900 12:00:00 AM

    3/6/1900 12:00:00 AM

     

    2012-04-24 07:48

    6/8/1900 12:00:00 AM

    3/22/1900 12:00:00 AM

    3/6/1900 12:00:00 AM

     

    2012-04-24 10:06

    6/5/1900 12:00:00 AM

    3/23/1900 12:00:00 AM

    3/7/1900 12:00:00 AM

     

    2012-04-24 10:35

    6/15/1900 12:00:00 AM

    3/28/1900 12:00:00 AM

    3/11/1900 12:00:00 AM

     

    2012-04-24 21:21

    6/4/1900 12:00:00 AM

    3/22/1900 12:00:00 AM

    3/7/1900 12:00:00 AM

     

    2012-04-25 06:44

    6/20/1900 12:00:00 AM

    3/25/1900 12:00:00 AM

    3/6/1900 12:00:00 AM

     

  • Wayne Contello Level 6 Level 6 (16,140 points)

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

  • gpken Level 1 Level 1 (0 points)

    A little additional information:

    The data is sent from my iPhone as an attachment. I also have the choice of sending it as CSV which does open with Numbers corectly.

  • Wayne Contello Level 6 Level 6 (16,140 points)

    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

  • gpken Level 1 Level 1 (0 points)

    I don't have MS Excel on this computer (iMac) but I did open the XLSX on my friends Macbook Air with Office 2011 and it did open the file okay. If I open the file with Numbers and then save it as an Excel document, it changes all colums to numbers - including the date colum.

    At this point I am giving up. It is far easier for me to send the file from my iPhone to my computer as a CSV and wotk with it in Numbers that way.

    Wayne, I appreciate your help, but I am spending more time on this than I care to. The problem somehow lies in the header and that is an Apple problem. If I really wanter to work with an XLS file I will install MS Office on this Mac, but for now I am happy with the CSV file.

    Thanks again

    Ken

  • Wayne Contello Level 6 Level 6 (16,140 points)

    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

  • gpken Level 1 Level 1 (0 points)

    Okay, Wayne, let's try this:

    I have an email attachment that contains my name. If I open it with Numbers, it is corrupted. If I try to remove my name and save it, it is still corrupted. The only way that I can send you the XLS file is to attach the original attachment. If this is acceptable to you, let me know. I don't mind having you and others know my name or measurements. I can even send you the email from my iPhone if you so want

    Ken

  • Wayne Contello Level 6 Level 6 (16,140 points)

    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. 

  • gpken Level 1 Level 1 (0 points)

    I can't find your email address in your profile

  • Wayne Contello Level 6 Level 6 (16,140 points)

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

  • gpken Level 1 Level 1 (0 points)

    There doesn't appear to be anything to the right of you name

Previous 1 2 Next