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

numbers

  1. RazorBackXX

    How to Batch Format Number Sequence in videos.

    I have a M1 Mac running Sonoma. I use a program called Downie to download music videos off my YouTube playlist, when I do this it creates a number sequence that can go up to 100. how do I format it to remove it? is there a shorthand way of doing it. everyday I batch rename photos & videos. & if...
  2. C

    Need help in Numbers

    I'm having trouble in numbers. I'm making a running log so I can keep track of my training. I have a table that has the date, duration, distance, average pace, ect. I have another table that I want to have it automatically find the top 5 fastest times for a certain distance (5K) and pull that...
  3. M

    Create a Numbers File

    I'd like to create a numbers file with a cover sheet that pulls data from each subsequent sheet when it is added. So each numbered row represents a Sheet in the file. Each lettered column represents a standard value from the sheets. The sheets are all uniform (except the first) and as I copy a...
  4. E

    macOS AppleScript - Active Pages Doc Rename issue. Hack job works. Obvious fix? Recursive or Relative Path issue?

    Ok, not sure if this correct area - its an AppleScript Pretty simple. It looks at a sampleSpreadsheet (Numbers), checks the values of Cells E2 and B2. Cell E2 is a "pop-up menu" data format (2 values right now: dropDownValue1 and dropDownValue2). B2 cell is text data format. If E2 is...
  5. R

    unable to load Pages or Numbers after dosdude1 upgrade to Catalina

    Upgraded to Mojave a year ago and lately started locking up with multiple screen images. Could not resolve the issue so I upgraded to Catalina using (dosdude1) Patch and OSX 10.15.7 . This solved the issue of locking up and now have a full version of Catalina running on 24" iMac early 2009 ...
  6. Wowfunhappy

    Any thoughts on Microsoft Office?

    Ever since first switching to OS X in 2010, I've been an iWork user. I always figured that if I was going to use Apple's operating system, I should also use the office suite Apple explicitly built for that operating system. Today, this means I'm using iWork '09 on OS X 10.9 Mavericks. Mavericks...
  7. C

    iCloud iCloud 'Numbers'; - how to duplicate spreadsheet

    Used to be so simple - I could right-click on the thumbnail and it gave me the option to rename, duplicate etc. Now - nothing! Anyone know how I can duplicate a spreadsheet within iCloud please?
  8. J

    Privacy: Apple collecting User Content through Pages, Numbers, Keynote... But what info exactly?

    Hi. This is a question about privacy issues on MacOS app created by Apple. According to Apple's data collection policy, which is open to the public, Apple is collecting various personal information (including "Data linked to the user") when you use their original app like Pages, Numbers and...
  9. D

    Is there any way to stop auto-formatting in Numbers?

    This has been driving me nuts for a while: I have a sheet with a whole column set to the Data Format "Currency". But whenever I actually enter any amount it automatically changes the Data Format to "Number". This really quite ridiculous. Is there any way to make the Data Format stick?
  10. L

    Numbers don't sort right

    Hi I'm trying to sort a column i Numbers, some of the rows are not sorted. Can anybody help?
  11. R

    Numbers Formula Help

    Hello, I need some help from the Numbers geniuses... or anyone that may know a bit about numbers formulas. In Column A I have the numbers of days ranging from 1-4. In Column B I have two options to select either Full or Half Days. In Column C I have dollar amounts. How can I get Column C to...
  12. Richardjfcavell

    iPhone Numbers for iOS - x axis help

    Hi. Here is my spreadsheet. What I want is for the x-axis values to be spread out in accordance with the dates. I’m working on an iPod touch. How do I do that?
  13. A

    Pages and Numbers on macOS Catalina 10.15

    Help! I just picked up a second hand, late 2013 27" iMac, and have started setting it up for my personal use. I went to the App Store to download Pages and Numbers, only to be hit with messages to the effect that these programs can't be installed because "macOS version 11 or later is...
  14. J

    Numbers Pivot table, Grand Total as Average

    I am using v11.2, which includes the new pivot table capabilities (most current version at the time of posting). I have a sheet with all my bank transactions from a CSV download. I have added a "Category" field to this sheet, for every transaction. Selecting all the transactions, I create a...
  15. T

    Trouble with Numbers Formula

    I’m having issues with a Numbers spreadsheet that wasn’t an issue under Excel. I have 3 columns E2 - “Payment Amount” F2 - ”Initial Balance“ and G2 - “New Balance” Then I have 12 columns representing the months of the year, which are L2 - W2. In Excel, I could do a formula that updated the...
  16. VideoBeagle

    macOS Using Applescript to Color Cells in NUMBERS

    I'm trying to take a list of Color Codes and spit out a chart with the colors actually visible. I'm trying the script* in this post from the Apple Support Forums: https://discussions.apple.com/thread/251970289 The script worked once on a sample.. but then not again (and it didn't work quite...
  17. A

    Apple Numbers - Key Log

    Hey all! This is a Apple Numbers related question. Where i work, we manage the keys and alarm codes for multiple properties over the local government area. We have contractors and employee's coming daily to collect multiple sets of keys and alarm codes for our buildings. We currently keep...
  18. OrangeCuse44

    iPad Copy + paste cell formatting in Numbers on iPad OS?

    I see how to do this on the Mac app but can’t see how to copy and paste cell formatting in Numbers on the iPad. Is it possible?
  19. Apple Knowledge Navigator

    iCloud Should Apple be doing more to compete with Google Workspace, et al?

    iCloud has a lot going for it provided you're in the Apple eco-system, but when it comes to larger productivity and business-centric tasks, I'd argue that Apple's platforms just aren't as scalable. Regardless, do you feel that this is area Apple should try to improve? Would you pay money for a...
  20. A

    macOS Applescript: exporting numbers file to PDF

    I have the following code to print a pages file: tell application "Pages" set Doc to open PathFileDoel as alias set DocPDF to PathFileDoelPDF export Doc to file DocPDF as PDF close Doc end tell Is there a similar command to export a numbers...