Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

numbers

  1. fishingfromakay

    Help finding an iWork 09 alternate please.

    Hello all, I am coming from a 2012, 13" MacBook Pro using iWork 09 to a M1 MacBook Pro. My dilemma is that I am in search of help with is finding an alternative to iWork 09. I really like iWork 09. Does anyone have any suggestions for a replacement ? I tried using the new Numbers on the New...
  2. R

    Apple Numbers: Use filter to find any cells containing values from column

    I've mostly worked with Excel before but I'm having to achieve what I'm trying to do with Apple's Numbers application. I have a spreadsheet full of values in column A on a table called Tracker. I would like a separate table, Filter Criteria, which contains 1 column where I can paste a bunch of...
  3. msephton

    Shared spreadsheet becomes locked and uneditable due to "available" Numbers update

    I have a Numbers spreadsheet that I have been editing and sharing with others for many years. Today, I see that my spreadsheet has become locked (uneditable, even after dismissing the notice) and that I am prompted to upgrade Numbers to a new version. However, I'm still running Mojave 10.14.6...
  4. P

    iWork Numbers formula not working

    I have a seemingly basic formula i am attempting for bookkeeping in a spreadsheet and cannot get it to work other than on one specific row of a spreadsheet. I attempted to do the formula in a new spreadsheet in case the previous one was corrupted or something with no luck. Basically I am...
  5. M

    Help please for random numbers appearing on Mac OS Catalina

    These numbers with arrows just started appearing on my mac...in excel, google, any app I'm using...anyone have any idea what they are and how to remove them? Thanks! Mallory
  6. M

    Why are Numbers, Pages, and related documents so large by comparison?

    I've noticed that taking a spreadsheet, word document, or similar from, say LIbreOffice, and moving that content to Numbers or Pages, the file size increases by a factor of about 20 times! For example, a simple word document takes about 20K, but that same document in pages is often around 600K...
  7. Fortun

    Universal Brainito - Words vs Numbers

    FREE Test your friends and your mental agility. Start a game with friends, family or new opponents to build words, create operations and train the mind. Words Round ► Form up to 3 words using some of the available letters and get points for each letter. Numbers Round ► Perform basic...
  8. B

    iMac Mid 2010 | Native Apps Outdated --> Install Catalina?

    Hi everyone, I'm Francesco from Italy. I currently own an iMac 21'' Mid 2010 equipped with 16 GB of RAM (Crucial) and a double-hard drive configuration (SSD + 1 HDD). The machine works fine, but I'm still stuck on Mac Os 10.13.6 (High Sierra). I use very frequently Pages, Numbers and Keynote...
  9. tombarnes

    iPad Contacts: Phone Number format NIGHTMARE

    I've scoured the forums for an answer on this! My devices, MacBook Pro, iPhone and personal iPad have been all in harmony and working just fine for years. I've just started using iMessage and other iCloud functions on my separate work iPad. However, my work iPad formats all my phone numbers in...
  10. Trouble1

    Formatting cell in Numbers

    Deleted
  11. Reality4711

    Numbers!!! for Idiot

    Is there a 'Numbers Guru' out there to take me through a basic first time set up. All I want to do is 1/a small spread sheet. with twelve rows (months) and weight in pounds in second column. 2/ a graph (or American Chart) with 'x' for weight between 150lb & 220lb against 'y' twelve (months)...
  12. al404

    Numbers import data inside a table

    Since I'm switching to a new app for time tracking that allows export in CSV format I would like to create a template for my report with numbers and inside the template I would like a table that imports data from CSV Is it possible?
  13. Y

    Spotlight searches contents of some Numbers spreadsheets but not others?

    Hi, In the past, I have been able to use Spotlight (usually via Finder) to search the contents of Numbers spreadsheet files. It is one of the most useful features to me of using a Mac. However, I've noticed today that it is no longer searching the contents of ALL the Numbers spreadsheets I...
  14. S

    iCloud vs MS One Drive Vs Amazon drive Vs others

    Hi I've been trying to evaluate a could storage bundle with basic "office productivity" tools like basic spread sheet, text editor and slides / power point like functionality etc. My spread sheet and text editor needs are basic - just simple tables, graphs, pivot tables, mail merge etc, and...
  15. R

    iPad Numbers Autogenerate Pages

    Hello, Just wondering, is there anyway to have numbers automatically generate pages? I have a massive spreadhseet, each row contains information on a different element. I can work eith the spreadsheet for data manipulation. However when it is time to present this information, I use have to use...
  16. walby

    Numbers Date and Time

    Hello, I am trying to add values in column A and have the a date/time stamp in column D. I have a question and my searches have not been helpful or the results are outdated. IF(ISBLANK($A3),"",NOW()) So the above formula works, if cell A3 is empty the date/time cell (D3) is blank. I enter a...
  17. remykonings29

    Collection numbers from dates in

    So in the screenshot attached here. I would like to collect all working hours that belong to a month into a single cell. soo I want to search for a certain data/month and collect those dates to make a summary for in a single cell belonging to a month. I'm not sure where to start. Thanks. Remy
  18. D

    Numbers for Mac: FIFO calculation?

    Looking for a FIFO (First in first out) formula that works with Number for Mac. Found examples for Excel in the web. However, they don't translate to Numbers. Simplified example: Date - Quantity - Price - Inventory event (sell or purchase) 1/1 - 10 - $1 (purchase) 2/1 - 15 - $2 (purchase) 3/1...
  19. S

    Differences between iWork for iPad and macOS

    What are the differences between office suite iWork (Pages, Numbers & Keynote) for iPad and macOS? Is the iPad version good enough for college work or do you need macOS version for that?
  20. rdyornot

    iWork Numbers: Need help creating custom cell data format for software version numbers

    I posted this in the apple support forums, but thought i'd try here as well. I have a spread sheet that tracks changes in various versions of a program. Because of the way software is assigned version numbers i'm having a hard time finding a cell format that will: a) sort by version number...