Numbers to Excel Issue

Discussion in 'iWork Forum' started by daker, Aug 25, 2011.

  1. daker
    Offline

    daker iPF Novice

    Joined:
    Jun 11, 2011
    Messages:
    10
    Thanks Received:
    0
    Trophy Points:
    0
    Ratings:
    +0 / 0
    Hello all. I have encountered an issue with converting my numbers documents to excel. When I open the file in excel, a green triangle fills the top left corner of the first row of cells. Excel says the number is saved as text. When I use pivot tables, a new data set appears from nowhere and I don't have a clue where it references from. Thanks!
  2. daker
    Offline

    daker iPF Novice

    Joined:
    Jun 11, 2011
    Messages:
    10
    Thanks Received:
    0
    Trophy Points:
    0
    Ratings:
    +0 / 0
    Sorry for the post, I figured out a solution.
  3. twerppoet
    Offline

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    16,172
    Thanks Received:
    1,938
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +2,134 / 1
    Thats a relief. I wouldn't even know where to start. And then there's the fact that I don't' have Excel, making testing a just a bit difficult. ;)

    I wonder if the problem would show up in OpenOffice.
  4. giradman
    Offline

    giradman iPad Guru

    Joined:
    Apr 26, 2011
    Messages:
    3,441
    Thanks Received:
    773
    Trophy Points:
    113
    Location:
    North Carolina
    Ratings:
    +829 / 0
    Hello Daker - you might want to explain your solution briefly; might help others w/ the same or a similar problem - just a courtesy to others. Thanks - :)
  5. daker
    Offline

    daker iPF Novice

    Joined:
    Jun 11, 2011
    Messages:
    10
    Thanks Received:
    0
    Trophy Points:
    0
    Ratings:
    +0 / 0
    Yes, sorry. Excel was correct in saying that the number was saved as text. When I went back to my spreadsheet in Numbers and tapped the problematic cells, the keyboard popped up and the T was highlighted for which type of data to input in the cell (text, number, date, checkmark are the options). I had to select the number option and input the numbers that way. Excel didn't recognize the numbers input from the text option I guess. This was difficult to explain, so let me know if you could follow.
  6. twerppoet
    Offline

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    16,172
    Thanks Received:
    1,938
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +2,134 / 1
    Made sense to me. Thanks.
  7. emingursoy
    Offline

    emingursoy iPF Noob

    Joined:
    Aug 30, 2011
    Messages:
    2
    Thanks Received:
    0
    Trophy Points:
    0
    Ratings:
    +0 / 0
    I just purchased numbers but it does not open excel file, i receive the message spreadsheet could not be imported. Can anyone help me aboy this? Thanks
  8. twerppoet
    Offline

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    16,172
    Thanks Received:
    1,938
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +2,134 / 1
    Did you use the standard .xls format when saving from Excel?

    What method did you use to import the spreadsheet into Numbers?

    Numbers may also have problems with advanced features in the Excel like pivot tables and scripting; though it should just tell you those features have been stripped and import anyway.
  9. emingursoy
    Offline

    emingursoy iPF Noob

    Joined:
    Aug 30, 2011
    Messages:
    2
    Thanks Received:
    0
    Trophy Points:
    0
    Ratings:
    +0 / 0
    I used idisk but the problem is i have a excel file little complicated i guess that is the reason it is not recognize. My excell file has some macros. Do you think this might be the case?
  10. twerppoet
    Offline

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    16,172
    Thanks Received:
    1,938
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +2,134 / 1
    Even if Numbers imported the file, it would strip the macros. It only supports basic features. Here are a couple of reviews that may give you an idea of what Numbers and similar solutions will do. No iPad app has the same full feature set of a desktop applications. To be certain it is a problem with the file and not a problem with importing try a simpler spreadsheet and see what happens.

    Compare iWorks, Office 2 HD, Documents to Go, QuickOffice by richsdams
    http://www.ipadforums.net/new-member-introductions-site-assistance/22431-hi-all.html

    Office Apps Comparison by RedCoil (details and examples, very long)
    http://www.ipadforums.net/iwork-forum/36629-office-app-comparison.html

Share This Page

Search tags for this page
apple numbers will.not recognize new entry in spreadsheet
,
apple numbers, how to import excel files
,

can a numbers file be imported into excel

,
can i convert numbers file to excel on ipad
,
can numbers open up an excel document and imput information
,
convert apple numbers file to excel
,
convert excel macro spreadsheet to mac numbers
,
dates from apple not converting correct to excel
,
excel converts number to date problem
,
excel file show in errors in numbers app
,
excel formula problem when i open the excell numbers change to dates
,
how input number into an excel file with ipad
,
import apple numbers into excel
,

import iwork numbers into excel

,

import numbers to excel

,
ipad numbers spreadsheet could not be imported
,
issue with number conversion in excel
,
problems with converting hyperlink from apple numbers to excel
,
problems with excel forms in mac numbers
,
problems with excel on ipad