Numbers - Anyone ever had trouble with it?

Discussion in 'Mac Apps and Mac App Store' started by MacGurl111, Mar 3, 2014.

  1. MacGurl111 macrumors 65816

    MacGurl111

    Joined:
    Feb 4, 2010
    Location:
    Seattle
    #1
    Before I enter some heavy data into Numbers, I want to ask a question. Has anyone had any kind of trouble sending it to another person who does not have "Numbers?" What about printing out the sheet? I've read some reviews through the App Store for Mac and that made me nervous.
    I'm thinking about downloading Office for Mac for 140.00 just for peace of mind.
    Any thoughts?
    Thank you for your time. :eek:
     
  2. Tumbleweed666 macrumors 68000

    Joined:
    Mar 20, 2009
    Location:
    Near London, UK.
    #2
    They would need to have Numbers to do something with the native Numbers file.
    You can save a Numbers file in excel format and send them that (assuming they have Excel), but unless it's very simple data and formulae then there might be features that cannot be translated.
    If your main use is sending the data to others who have Excel, if it's anything more than very basic tables and charts then you should use Excel. However, are you sure they have it?
     
  3. MacGurl111 thread starter macrumors 65816

    MacGurl111

    Joined:
    Feb 4, 2010
    Location:
    Seattle
    #3
    Thank you for your response!
    I know my church has Excel for sure. I was there earlier. They are using PCs/excels to enter data. (Older computers).
    I need to enter data for them and it's a lot of information. Thank you for answering, I think it is best I go with Excel, just to be safe.
     
  4. Gregg2 macrumors 603

    Joined:
    May 22, 2008
    Location:
    Milwaukee, WI
    #4
    I think the free Libre Office will open Numbers files. I've used it to open AppleWorks files. Now the formatting might not be perfect...
     
  5. mtngoatjoe macrumors regular

    mtngoatjoe

    Joined:
    Jun 10, 2008
    #5
    If you're just entering data, then Numbers will work fine. You (or they) coudl just open the Excel file you export, and copy and paste into their master file. Or, if you're maintaining the master file and they just need a report, then you could send them a PDF.

    The great thing about Numbers is that you can work on it with a Mac, PC, iPhone, or iPad.
     
  6. Fishrrman macrumors G4

    Fishrrman

    Joined:
    Feb 20, 2009
    #6
    If you just want "compatibility" with Excel, you can use Numbers or LibreOffice. Keep the formatting simple, and everything else should "go through" ok.

    Also, there's a lightweight spreadsheet app out there that you also might consider, called "Tables". I prefer it to ALL of the "heavyweight" apps. And it can export to Excel, Open Document Format, pdf, and comma-separated values.
     
  7. mtngoatjoe macrumors regular

    mtngoatjoe

    Joined:
    Jun 10, 2008
    #7
    I should also mention that I think Numbers is MUCH better at formatting data so it looks good for presentations. You can have multiple tables on a sheet, and the tables can even overlap each other, making it very flexible for summarizing data. For complex analysis, I think Excel is better, but most people simply use Excel to track and display simple data (and for that, Numbers is better). YMMV.
     
  8. snberk103 macrumors 603

    Joined:
    Oct 22, 2007
    Location:
    An Island in the Salish Sea
    #8
    If you really want to use Numbers, just try a small test file. I've exchanged data with Excel users generally with no issues. The one place that I have had issues is with dates so make sure that you format your dates the same way as the Excel master file. For example... if the Church Excel file is expecting YY-MM-DD and you send your data in to them as DD-MM-YY - well you can see the problem. The other issue is general text that looks like a date to Excel when importing. For example - I was sending my bookkeeping info to my accountant, and the account numbers (which had dashes in them) looked like dates to Excel. This might happen whether you are using Excel or Numbers... so import a couple of small test files a broad range of the kind of data you will exchanging - and double check to make sure it's imported correctly.

    Luck.
     

Share This Page