Welcome to iPadForums.net Guest - Click Here to Register

Numbers to Excel Issue

This is a discussion on Numbers to Excel Issue within the iWork Forum forums, part of the iPad App Store category; 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 ...

iPadForums.net is the original Apple iPad Forum! Registered Users do not see these ads. Please Register - It's Free!
+ Reply to Thread
Results 1 to 10 of 10
  1. #1
    iPF Novice
    Member #
    65069
    Join Date
    Jun 2011
    Posts
    10

    Numbers to Excel Issue

    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. Ads


  3. #2
    iPF Novice
    Member #
    65069
    Join Date
    Jun 2011
    Posts
    10
    Sorry for the post, I figured out a solution.

  4. #3
    iPF Legend
    Member #
    28530
    Liked
    1523 times
    Join Date
    Jan 2011
    Location
    Walla Walla, WA
    Posts
    15,432
    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.

  5. #4
    iPad Guru
    Member #
    49414
    Liked
    467 times
    Join Date
    Apr 2011
    Location
    North Carolina
    Posts
    3,128
    Quote Originally Posted by daker View Post
    Sorry for the post, I figured out a solution.
    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 -

  6. #5
    iPF Novice
    Member #
    65069
    Join Date
    Jun 2011
    Posts
    10
    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.

  7. #6
    iPF Legend
    Member #
    28530
    Liked
    1523 times
    Join Date
    Jan 2011
    Location
    Walla Walla, WA
    Posts
    15,432
    Made sense to me. Thanks.

  8. #7
    iPad Noob!
    Member #
    93738
    Join Date
    Aug 2011
    Posts
    2
    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

  9. #8
    iPF Legend
    Member #
    28530
    Liked
    1523 times
    Join Date
    Jan 2011
    Location
    Walla Walla, WA
    Posts
    15,432
    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.

  10. #9
    iPad Noob!
    Member #
    93738
    Join Date
    Aug 2011
    Posts
    2
    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?

  11. #10
    iPF Legend
    Member #
    28530
    Liked
    1523 times
    Join Date
    Jan 2011
    Location
    Walla Walla, WA
    Posts
    15,432
    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...31-hi-all.html

    Office Apps Comparison by RedCoil (details and examples, very long)
    http://www.ipadforums.net/iwork-foru...omparison.html


Links

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Similar Threads

  1. Column/Row letters/numbers in Numbers
    By MikeV99 in forum iPad Apps
    Replies: 3
    Last Post: 07-22-2011, 02:10 PM
  2. Strange excel graphs in numbers
    By takenomorimonster in forum iPad Help
    Replies: 1
    Last Post: 07-05-2011, 05:29 PM
  3. Excel spreadsheet row numbers
    By candirisk in forum iPad Help
    Replies: 1
    Last Post: 06-22-2011, 12:27 AM
  4. Numbers - running MS excel functions
    By Jaquin in forum iPad General Discussions
    Replies: 1
    Last Post: 12-08-2010, 03:12 PM
  5. Best Excel App
    By RAC in forum iPad General Discussions
    Replies: 11
    Last Post: 10-20-2010, 01:46 PM

Search tags for this page

can a numbers file be imported into excel
,
can you import iwork numbers into excel
,
import iwork numbers into excel
,
import numbers to excel
,
issues with numbers import of excel
,
iwork numbers exporting problems
,
numbers 08 will not open xls
,

numbers to excel

Click on a term to search for related topics.