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)
You can change the formatting after importing to Numbers rather than "Automatic" using the cells inspector.
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.
can you post what the data looks like after importing into Numbers?
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 | |
My bad on two accounts: 1) please omit the persons name in the data and 2) post the data from Excel
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.
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:
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
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
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
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. 😉
I can't find your email address in your profile
you click my picture and it is to the right of my name
There doesn't appear to be anything to the right of you name
My bad. I logged out then clicked on my picture and the email is not visible. Sorry for the red herring...:
My email address is my first name at my last name dot net
Opening an xls file in Numbers
