Applications :: Keep Blank Cell In Numbers?
Oct 4, 2010The 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
ADVERTISEMENT
Applications :: Conditionally Filling A Cell With Blank?
Mar 27, 2010I would like to fill some cells in numbers conditionally with blank. These cells are in a table which is used to fill one chart. So I dont want the cells to have a value of zero. Alternatively, is there a function which returns the value in a cell?
View 2 Replies View RelatedSoftware :: Copying Borders From One Cell To Another In Numbers
Apr 3, 2010Does anyone know why copying borders from one cell to another in Numbers doesn't work? It's pretty inefficient creating borders for each cell all over the place.
View 3 Replies View RelatedMacBook Pro :: Print Cell Borders Using Numbers 09?
May 30, 2012How can I print cell borders using Numbers 09?
Info:MacBook Pro (13-inch Late 2011), iOS 5.1.1, Numbers
MacBook Pro :: Merge Multiple Cells Into One Cell In Numbers?
Apr 18, 2012I'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
OS X Technologies :: Applescript To Cut And Paste First Word Of Numbers Cell
May 19, 2012I'm creating a Service in Automator, and would like incorporate an Apple script that will "cut" the first word in any Numbers cell that I select, and "paste" it into the cell directly to the left of the the cell I've selected. Let's assume the column I'm selecting from is Column C. As a very rough start, here is what I have (with some of things I'm trying to accomplish in brackets): on run {input, parameters} try set MyText to input as string set FirstWord to first word of MyText set [remove the first word and a single space from what I've selected]tell application "Numbers"tell table 1 of sheet 1 of document 1 set theRow to [the row of the cell I've selected] set value of cell 3 of theRow to FirstWord end tellend tell end try return inputend run.
View 7 Replies View RelatedApplications :: How Do I Fill A Column With Numbers And Equations Automatically In Numbers
Jul 17, 2010I'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"
Applications :: Input Numbers In Numbers As Degrees Instead Of Radians?
Mar 24, 2009See 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.
Applications :: Click 10 - 20 Times In New Cell - Excel
Jan 30, 2010In excel, whenever I try to type in a cell, I must press the first key 10-20 times before it shows up. It doesn't show up delayed, as in it shows up with 20 a's, it just shows one. Once the first key shows I can type anything else in that cell, but when i hit an arrow key or click to go to another cell, I have to hit the first letter 10-20 times again. I have to click 10-20 times to click into a new cell as well. This just started today. I've tried restarting excel a few times, but It didn't help.
View 5 Replies View RelatedApplications :: Conditionally Formatting Cell (Different Color)
Mar 28, 2010I am working with a spreadsheet. I need to conditionally format a cell (a different color), if that cell is referenced in any other cell. I use iwork08.
View 1 Replies View RelatedApplications :: Send SMS From Mac Via My Mobile / Cell Phone Number?
Oct 31, 2010I'm looking for a program/app that will allow me to primarily send SMS from my Mac using my current phone number. Does anyone know if anything like this exists? I can only think of something like this working in one of two ways: Sending an SMS composed on my Mac through my mobile/cell, via Bluetooth or some other method? OR Using software that emulates my mobile number to compose and send SMS?
I remember back in the day you could actually email an SMS to a phone by using their mobile number as a username and their network as the domain - e.g. 07123456789@orange.net. Unfortunately, because pretty much all the networks now provide email services too, doing that nowadays means they will actually receive an email at their online account instead of their SMS inbox.......................
Applications :: Notify If Forget To Enter Date In Specific Cell
Apr 1, 2009I am trying to figure a way to notify me when I forget to enter data in specific cells, that need to be filled in. I included a screen shot. What I want it to show is basically fill in the whole row in red or another color. When I forgot to input data. Is there a formula?
View 2 Replies View RelatedApplications :: Excel - Number Hidden Beneath Cell's Displayed Text ... Possible?
Feb 21, 2010Is there a way to have a cell display text, but behind the text is actually a number figure that I can ask Excel to use in calculations? I'll explain what I mean to give you a visual so you'll understand what I'm trying to do. I want to create a monthly budget in an Excel spreadsheet. I'll have one row for each day of the month, and maybe 3 or 4 columns for in which to put expenditures for each day.
Let's say on the 4th of the month I have a Visa bill due, I usually put gas in my car and I pick up some Dry Cleaning. I'd like to be able to type Visa, Gas and Dry Cleaning within the row of cells for the 4th, and have the dollar amounts for those expenditures hidden beneath the text. Then I'd do a summation formula in the last column to tabulate all of the hidden dollar amounts to give me a total for that day. This way, I can see a total expenditure figures for that day (in the summation column) and what the money went to, without having to do the spreadsheet the old-fashioned way of putting the Text in one cell and the dollar figures in an adjoining cell (which in this case wouldn't work in a columnar sense since the text cell would have to be either above the dollar cell, thus making the text cell in the previous day's row...or, putting the text in say, cell B2, and the dollars in row B3, and doing the same for multiple charges per day, which would make for a very wide spreadsheet.
Applications :: Pages (iWork) - Finding Keyboard Shortcut To Edit Cell Contents?
Jan 8, 2008In iWork 08's Pages application, I need a keyboard shortcut to edit the cell contents. Example: current cell contains the text "new client" -- I decide I want it to read "new clients" without typing it all over again. In Excel for Windows, I would hit F2, that would give me a cursor at the end of the word "client" and I was good to go.
View 1 Replies View RelatedApplications :: .3g2 (3gpp2) File Converter To Import Video From Cell Phone To Imovie
Apr 16, 2009get video recorded from my cell phone (motoroala Hint) imported into imovie so I can edit the video and merge clips. The file extension of the video file is .3g2 . Quicktime will play this video, but imovie apparently does not support it. I have found a number of different video apps by searching forums (iskysoft imedia converter, handbreak, mpeg streamclip, applemacsoft video converter) of which only iskysoft imedia converter does what I want to do. The only problem is the trial version does not convert audio and has "evaluation copy" imprinted into the video. The full version costs $50
View 3 Replies View RelatedMacBook Pro :: Change India Numbers To Arabic Numbers?
May 22, 2012how to change india numbers to arabic numbers?
Info:
MacBook
Pro, Mac OS X (10.6.7)
Applications :: Getting A Percent In Numbers?
Mar 8, 2010I'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 RelatedApplications :: Creating Graphs In Numbers?
Oct 19, 2010I 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.
Applications :: IWorks 08 - Numbers Freezing?
Jun 30, 2008I'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.
Applications :: Using Numbers For Accounts Receivable
Feb 13, 2009I 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 RelatedApplications :: Unable To Use Numbers Formula
Mar 14, 2009I'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.
Applications :: Finding Mac Numbers Formula
May 27, 2009I 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 RelatedApplications :: Numbers - How To Rename Cells
Sep 26, 2009In 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 RelatedApplications :: Saving As Excel In Numbers
Oct 28, 2009I 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 RelatedApplications :: Rounding Numbers In Excel?
Nov 28, 2009A 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.
Applications :: Mac Pages - Using Different Page Numbers
Jan 4, 2010I 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.
Applications :: Using Excel Formula In Numbers
Feb 22, 2010I 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.
Applications :: Changing Numbers To Hours?
Apr 15, 2010When 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?
Applications :: Can Download More Templates For Numbers
May 10, 2010I 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 RelatedOS X V10.7 Lion :: Applications With Serial Numbers From Old To New Mac
Jun 15, 2012I 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)
