MacBook Air :: Use NOW() In Numbers?

Feb 11, 2012

I've recently switched from the dark side to Apple and am converting an Excel spreadsheeet. The spreadshet keeps track of subscriptions, things that a re due once a year, etc.. One of the spreasheet's formulas uses 'NOW()'.. The user can specify a day-range, like 15, so that the spreadsheet would highlight due dates within 15 days..   MS handles dates in serial numbers which allows date comparisons ( I'm guessing you already know all of this ) .. anyway, For example, the user enters the renewal or due date in a certain cell and then the next cell would subtract that date's serial number from the current date's serial number using something like 'B3-NOW()'.. The resulting number could be cast to an integer and compared to the '15' .. and if the result is less than that, aka 'due within 15 days', then the cell would be highlighted red..  I gave up on the conditional formatting but I don't know how to use the equivalent of 'NOW()'..

Info:
iPhone 3G, Mac OS X (10.7.3), Excel to Numbers

View 3 Replies


ADVERTISEMENT

MacBook Pro :: Change India Numbers To Arabic Numbers?

May 22, 2012

how to change india numbers to arabic numbers?

Info:
MacBook
Pro, Mac OS X (10.6.7)

View 3 Replies View Related

Applications :: How Do I Fill A Column With Numbers And Equations Automatically In Numbers

Jul 17, 2010

I'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"

View 1 Replies View Related

Applications :: Input Numbers In Numbers As Degrees Instead Of Radians?

Mar 24, 2009

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.

View 3 Replies View Related

MacBook Pro :: Add Shapes To Numbers?

Apr 5, 2012

I am building a rendering of a catering facility I am working with and need to create some funky tables for my template. how I could get more shapes in to numbers to choose from? 

Info:
MacBook Pro, Mac OS X (10.7.3)

View 2 Replies View Related

MacBook Pro :: Get Pages And Numbers With A New?

May 21, 2012

Ive recently purchased a macbook pro, I previously had one with snow leapord on it, this new one has lion, Ive just  noticed it doesnt seem to have pages or numbers installed, is this correct?

Info:
MacBook Pro, Mac OS X (10.7.4)

View 1 Replies View Related

MacBook Pro :: Finding Part Numbers

May 31, 2010

Where on the system do you find the part number for the new MBPs?

View 9 Replies View Related

MacBook Air :: Is It Normal For The Mac Numbers App To Be Taking Up 99.7% Of CPU

Apr 2, 2012

I have just downloaded Numbers for mac, I have a Macbook Air, July 2011, Mac OS X (10.7.3), 1.7Ghz Intel Core i5 4 GB DDR3. I have opened numbers, and it is sucking up CPU, if I click on something, it jumps up to 99.7%!! I currently have two sheets open, one with a text box, empty graph and empty table, the other sheet, just an empty table.. When I click on anything, the app locks up and i get a pinwheel. (until it sorts itself out, a good while later!) 

Info:
MacBook Air, Mac OS X (10.7.3), 1.7Ghz Intel Core i5 4 GB DDR3

View 1 Replies View Related

MacBook Air :: Pages And Numbers Update

Aug 26, 2014

i have a macbook air mid 2013..os x yosemite 10.10

I have a problem with the application "pages" and "numbers". on the app store there is an update for each one, but the download does not start. Even if I delete the app and redownload again, the download gets stuck. i can't use these apps.

Info:
MacBook Air

View 1 Replies View Related

Applications :: Can't Open Numbers Doc From Mobile Me On MacBook Air?

Oct 15, 2010

Got a weird problem. I store alot of documents on my iDisk so I can access them on either my MacBook Air or my iMac. It has worked great for several years.

I'm using Numbers '08 on both computers and both computers are completely updated.

Several weeks ago, the MacBook Air quit allowing me to open a Numbers document stored on Mobile Me. When I try to open a Numbers doc, I get a message saying, "The document could not be opened."

However, all is fine on my iMac. All numbers documents will open as normal from Mobile Me.

Also, other types of documents will open fine on the MacBook Air from Mobile Me i.e. Preview, Pages.

I tried copying a Numbers doc from Mobile Me to the Air, but I get an error stating, "The operation can be completed because and unexpected error occurred(error code -8084)."

Also, If I'm not dealing with Mobile Me, Numbers seems to work fine on the Air. I can create documents and open them fine.

In desperation, I did a clean install on the Air, but to no avail. I still have the same problem.

I can't think of anything I did to the Air to make it suddenly quit opening docs from Mobile Me.

View 2 Replies View Related

MacBook Pro :: Keyboard Part Numbers - Need Replacement

Aug 1, 2009

I just made the transition from PC and bought a MBP Santa Rosa 2.2Ghz Duo with 2 keys(the cursor down and right) that do not work. Presumably the entire keyboard needs replacement. Does anyone know if 922-8035 the same as 922-7183? Several sites advertise them together, and others individually. The reason this is important is the price discrepancy, plus I want to get a Russian (Cyrillic) keyboard and there is a good one listed as 922-7183 but I want to make sure it is the same as 922-8035.

View 1 Replies View Related

MacBook Pro :: Screen Resolution Chart With Corresponding DPI Numbers?

May 3, 2010

Does anyone have a link to a chart of the various screen resolutions and their corresponding dpi numbers? I have been trying to find one and have been woefully unsuccessful thus far. I would just like to compare the different resolutions of computers I have, and have used, vs. the new mpb resolutions.

View 4 Replies View Related

MacBook Pro :: Print Sheet Titles From Numbers?

Jan 31, 2012

how can I print sheet titles from Numbers?

Info:
MacBook Pro, Mac OS X (10.6.8)

View 1 Replies View Related

MacBook :: Make Negative Numbers Red On A Spreadsheet?

Feb 7, 2012

How can I make negative numbers red on a spreadsheet while keeping positive numbers black?

Info:
MacBook (13-inch Aluminum Late 2008), Mac OS X (10.7.3)

View 1 Replies View Related

MacBook Pro :: Borders Around Individual Cells In A Row In Numbers?

Feb 16, 2012

How do you put a border around the whole cell in a row of cells, ie  Totals of several columns in the Numbers s/s.?

Info:
MacBook Pro, Mac OS X (10.6.8)

View 2 Replies View Related

MacBook Pro :: Words On It Changed To Numbers/codes?

Mar 8, 2012

When I am using programs like 'Finder' and I'm trying to select different options, for some reason the words such as, 'Arrange by', 'Date created' etc have all changed to number and letter codes, I don't know how I've done this or how to change it back. They all still work if you select them, I just can't read what I'm selecting.

Info:
MacBook Pro, Mac OS X (10.6.8)

View 1 Replies View Related

MacBook Pro :: Its Clock Is Running Negative Numbers

Apr 24, 2012

My Macbook Pro clock is running negative numbers.

Info:MacBookPro, Mac OS X (10.5.8)

View 3 Replies View Related

MacBook :: Numbers Keep Shutting Down Sf-compatibility Error?

Apr 30, 2012

Numbers keeps shutting down on me.The message the last time said sfcompatability error.

Info:
MacBook, Mac OS X (10.6.8)

View 1 Replies View Related

ICloud :: Using MacBook Pro Files With Numbers On IPad?

May 23, 2012

I have Numbers on my MacBook Pro and would like to send files to iCloud so I can use it with numbers on my iPad. How do I do This?

Info:
iPad, iOS 5.1.1

View 1 Replies View Related

MacBook Pro :: Print Cell Borders Using Numbers 09?

May 30, 2012

How can I print cell borders using Numbers 09?

Info:MacBook Pro (13-inch Late 2011), iOS 5.1.1, Numbers

View 1 Replies View Related

MacBook :: How To Change Y Axis Numbers To Letters

Jun 16, 2012

I have found a previous conversation, see community converation titled:  Label Y-Axis as letters, not numbers?

it describes how to do what I want. I understand this described process but I cannot figure out where to place the "lookup" formula for it to work.  Do I select the whole table, one column, etc.  I have tried to recreate the screen shot sample but get stumped at the formula placement.  I need to graph reading levels from a-z with the y-axis being letters not numbers and this old conversation  has created this.  I have been searching the web for 4 hours and got no where until I found this discussion and now I am so close...

Info:
excel, charts, Mac OS X (10.6.8)

View 1 Replies View Related

MacBook Pro :: Send A Numbers File To Someone Who Has Excel?

Jun 20, 2012

how can I send a Numbers file to someone who has excel

Info:
MacBook Pro, Mac OS X (10.6.8)

View 1 Replies View Related

MacBook Air :: IMessage Is Not Working - No Numbers Are Registered

Sep 10, 2014

My iMessage on my Macbook Air is not working. It is saying that no numbers are registered with iMessage, when i know they are because i am texting them off iMessage with my iPhone. Also, i am not receiving any of my text messages from my iPhone to my iMessage on my macbook.

Info:
MacBook Air

View 2 Replies View Related

MacBook Air :: Register Phone Numbers To IMessage?

Sep 6, 2014

My mac doesn't let me send messages to phone numbers because they aren't register with iMessage yet? how do i register them?

Info:
MacBook Air, iOS 7.1.2

View 1 Replies View Related

MacBook Pro :: Possible To Export Address Book To Numbers Or Excel?

Apr 3, 2012

Can I export contacts from Address book to Numbers or Excel?

Info:
MacBook Pro, Mac OS X (10.7.3)

View 1 Replies View Related

MacBook Pro :: Merge Multiple Cells Into One Cell In Numbers?

Apr 18, 2012

I'm trying to make a mailing list and take information from multiple cells in numbers and put into one cell to print.  Anyone know how this is done? 

Info:
MacBook Pro

View 1 Replies View Related

ITunes :: Numbers Does Not Sync Blackberry Nextel To Macbook Air?

Jun 21, 2012

I have problems synchronizing nextel numbers in my country starting with number 51.I start to sync with itune and ends normally but, in reviewing my contacts in Outlook appear but only with nextel number of fixed and mobile numbers.

Info:
MacBook Air, Mac OS X (10.7)

View 1 Replies View Related

MacBook Pro :: Why Can't Open Numbers Document Saved To Desktop

Sep 4, 2014

I was trying to open an existing Numbers document saved to my desktop. It took me to the App Store, but I didn't have access to a Wireless network. If it needed an update, why does it require the update to open an existing/previously saved document? 

Info:
MacBook Pro with Retina display

View 1 Replies View Related

MacBook Pro :: Does Software Update To Pages / Numbers / IBooks

Jun 17, 2014

Does software update to pages, numbers , iBooks etc incur any cost or are the updates free?

Info:
MacBook Pro

View 1 Replies View Related

MacBook Pro :: Contacts Suddenly Hiding Some Names And Numbers Not Others?

Dec 3, 2014

Contacts suddenly hiding some names and numbers not others.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved