I'm trying to insert the current time into a cell formatted to take the date & time where the date is omitted from the format, but the time is enabled. It's giving me 12:00 AM as the current static time.
View 2 RepliesiMac OS X version 10.9.4 showing Numbers '09 version 2.3. I installed Numbers version 3.2.2 on August 28, 2014. But Numbers will not permit me to open any documents in iCloud Numbers by a pop-up indicating I need the newer version of Numbers 3.2.2!!!!! When I go to AppStore to do so, it shows I installed it in August and will not permit me to get it.
I also have an iPod with the latest version
Info:
iMac, Mac OS X (10.7.5), MacBook OS x (10.7.4); iPad NEW
So I'm working this job where I need to keep track of my hours. I have rows of 4 columns. A is just the date and other random task info. B is the starting time, C is the ending time and D should be how many hours I worked on that particular day. The only problem is, I can't for the life of me figure out how to get Numbers to add up my hours automatically!! The SUM function just gives me the red triangle of WTF. It's probably something really simple but this is my first attempt at spread sheeting so easy on me.
View 3 Replies View RelatedI've been ripping my hair out trying to find the answer to this.
In Numbers for Mac, I need to fill a column automatically with a series of integers (1 - 50) and then the next column with a function that interacts with the first column.
For example:
Column A - 1 - 5
Column B - (value in Column A * 5)
I can't figure out how to do it in Numbers When I try to fill column a with 1 - 50 all it does is fill all 1's and I cant find an option how to make that change so it automatically numbers when I highlight them.
The best I can describe is how in Excel you can type 1 in the first cell, then highlight a bunch of cells and the little box appears that lets you click "Fill Series"
See above title. i get that there's the "degree(cell)" function, but there has to be an easier way to change the settings so you can just input in degrees rather than radians.
like how calculators have a degrees and radians mode, i find it so hard to believe that there isn't one in numbers. if there really isn't, this is an incredibly flawed program.
When using Time Machine on my new iMac the number of megabytes remaining for backup seem to be mistaken. Each time it starts up is says that it has about 925MB remaining to back up. It will then back up about 2MB and then it will finish that. It then says preparing and will do about a 1MB backup and will say it is finished.
View 2 Replies View RelatedI have two computers in different locations and want to use time machine to keep them both current. Spend about 6 months in each location and got tired of transporting the iMacs. One of the iMacs is a mid 2010, the other is brand new. When I try to restore from the new machine to the old one, it doesn't work. Keeps waiting for a permission.
View 2 Replies View RelatedSo if my current setup on my Mac Pro is (2) 1 TB drives.
(1) for use, and (1) for Time Machine.
Can I connect a 1 TB Time Capsule to essentially "back up my Time Machine back up"?
So I want to have (3) 1 TB HDD's, (2) in the Mac Pro, and (1) in the Time Capsule, all with the same information. I basically need to know if the software is set up for a 1X's backup only, or can it copy the same information again as a redundant backup?
I have windows 7 installed on my macbook (aluminum body) via bootcamp, but whenever i use windows the clock is 4 hours ahead of the current time, and if i change it and go back to using snow leopard the clock is 4 hours back, i already tried syning with windows time and apple time, but nothing, any tips?
View 4 Replies View RelatedI recently wiped my hard drive and reinstalled snow leopard from scratch, but not before doing a Time Machine Backup just in case.
I did not restore my whole system from time machine because I do not plan on keeping everything I had.
Anyways, I just hooked time machine up and restored some of my old applications. When opening these applications it is asking me for the serial numbers or registrations.
I want to replace my current HDD with new SSD, here is the steps I will do, identify if this is feasible!!!
1. Put ssd in a external hard drive enclosure
2. Connect the external SSD drive to MBP
3. Back up the entire OS and files with time machine
4. Remove the enclosure, take out ssd
5. Put SSD in mu MBP, replacing HDD
Will this work?
Figured it would be a little lighter to have a thread that shows that Apple's computer CAN and DO work occasionally....Here's my uptime on my i7! It wants me to reboot for Safari update, but I refuse. As of 8:42am PST, March 16, 2010:I guess currently I have the longest uptime of anyone in this thread!
View 12 Replies View RelatedI just bought the 2TB TC about a month ago. Now that the improved TC is about to be released I'm going to swap out the current one for the newer one.My question is do I have to do anything before I swap them out? Probably just a clean swipe of the data on the current TC, but anything else? How do I erase everything on the current time capsule?
View 1 Replies View RelatedCan I restore the current iPhoto using my Time Machine back-up? If so (I hope & pray), how would I do that?
Info:
iMac, Mac OS X (10.6.7)
how to change india numbers to arabic numbers?
Info:
MacBook
Pro, Mac OS X (10.6.7)
I'm having trouble get percentages in numbers. I want to get 5% of one cell and display the answer in another. Whats the formula for this.
View 4 Replies View RelatedThe v_products_url_1 column is blank, but it contains information from the previous column. Is there any way to not have the previous cell overlap the empty one?
View 3 Replies View RelatedI just have a quick question about Numbers (iWork '09). I need to graph some supply and demand graphs for school. How would I go about doing this? Whenever I create a graph based on a chart, it just plots each row as it's own line. I can only edit the values in the Y-axis, and obviously I need to be able to work with the X-axis as well.
Update: I played around with it more and figured it out. I guess you have to graph it as a scatter plot and then choose to connect the dots, and remove the dots, rather than choose the line graph, whose icon looks just like a graph of supply and demand.
I'm a recent switcher from Excel to Numbers. For the life of me, I cannot find a way in Numbers to "freeze" headings so that as you scroll down or across the sheet they remain visible.
I'd be grateful for help; the matter is not covered in the video tutorials, nor in my little manual that came with iWorks, nor on the Help Menu.
I am using numbers for my accounts receivable. I have a formula which some dude created for me *years* ago that I used in Claris Works and it *seems* to work most of the time in Numbers. Anyway, the formula provides for either a debit or a credit and a balance. This is how it normally looks. However, for some weird reason the balance gets all screwed up whenever I enter cents into the equation. Check this out. I entered 5192 in the credit section and it changed the balance accordingly. However, when I add the 70 cents (.70) to the credit, the balance looks all messed up.
View 2 Replies View RelatedI'm trying to create a template for legal billing. The only thing I'm really having a problem with is the formula that multiplies time by hourly rate. The time spent cells are formatted to show it as 4h 5m ... and that totals perfectly with the SUM formula. When I multiply it with a rate cell formatted to currency the math is fine, but the format stays as 00h 00m ... even when I format that cell to currency.
I want to set up a cell that has a number in it. That number is to decrease by one every seven days is there a formula that I can use to do this automatically
View 2 Replies View RelatedIn Excel, you can easily rename a cell to whatever you want. i.e from A1 to yaxis How do you do this in Numbers? I can't find it.
View 1 Replies View RelatedI recently bought a Macbook Pro (and loving it) with iWork 09 pre-installed. I really like using numbers compared to office. However, I have just started working in a group where all the other members use Windows with Office 2007. I have been able to save my numbers (and pages) documents as the office equivalent. My problem lies when I am working on a document in numbers that is the office format. I like to continuously save my progress but whenever i press save, I have to save it as a whole new document or replace the existing one. When I used to work in office 2007 I used to just press save every now and then and it would save my changes. Am I doing something wrong or is it because I am working on an excel spreadsheet in numbers (word document in pages)?
View 3 Replies View RelatedA sheet of ply comes 1220mm wide and my staircase is 1200 wide. Therefore I get two out of one cut of ply. Used an 'if' function <1220 to divide by two as I get two out of one sheet if it's less than 1220.
Cell D11 calculates the amount of ply (as width measurement) needed by using an 'if' function, and E11 works it out as an actual sheet. The problem is it's showing 0.47 instead of rounding it to the nearest whole sheet (1), even if only 10mm is used I need to buy a whole sheet.
I just wanted to know how I could start the page numbers in header and footer on the third page of my document. The first page is the title page and the second page is the table of contents, and of course I wouldn't want the page numbers to be on those pages.
I have searched on the web and in help but couldn't find anything.
I am a newly converted Mac user and have some entrenched Excel habits, and try as I might, I couldn't locate this Excel formula in Numbers.
In Excel, I use "=C55 (or cell reference)" to copy that particular value from one worksheet to another.
I do this by clicking on the cell where I want the value to be copied to, type = and then switch to the other worksheet and click on the cell I want to copy. And voila, I am now back onto my 1st worksheet with the value showing. I do this because the value I want to copy to this cell changes regularly.
When I format a cell as time (13:30), why does it go to 00:00 when i enter "2." I want it to go to 2:00, but the only way to do it is enter the colon myself... there must be a way to enter "2" and have the cell show "2:00."
I am trying to compare an estimated time to actual time. The problem is my estimate is 4-5 hours. How can I make 4-5 hours show up(in number format) in one cell... is that even possible or do I need to make two cells, one for min time and one for max time?
I just got into using Numbers, it's awesome, the templates are great, but I'd like some alternative ones if possible. Especially comparison tables. I'm ok with using the same template for eternity, it would just look better if I didn't.
View 2 Replies View RelatedI just purchased a new Retina Display MBP as an upgrade to my old iMac.I have over 200 Applications taking up the bulk of my drive, many of which have serial numbers that I no longer even know of due to loss of original boxes, or what have you. I am trying to avoid copying all of my content over to the new MBP, I would much rather just move what I actually need to and try to keep it a little "cleaner". So my question is, with a Time Machine Backup of my iMac... Can I plug that into the MacBook Pro, launch Time Machine, and simply drag the last backup's Applications over? Will the ones with the serial numbers run?
Info:
iMac (21.5-inch Mid 2010), Mac OS X (10.7.3)
