Every time I change the cell format in numbers, it keeps going back to 12/30/11 when I want 2/1/12. It is quite frustrating because I did what it said to do.
View 2 Replies
I am wondering if there is a way to take an excel spreadsheet in numbers and change the format to alphabetical - the person did the list by DOB and that is just not helpful to me in finding clients?
Info:
iMac, Mac OS X (10.6.8)
I use office 08 for excel. Some of the boxes I use are formatted so when I enter the date say 22feb hit enter, it corrects it to read Feb. 22. When I import into numbers, and try to do it, there is no format for that cell, I type 22feb, and that s what shows in the cell, Is there a way of formatting these to do the way the excel spreedsheet works?
View 2 Replies View RelatedEvery question I see about changing the screenshot format here seems overly complicated, or requires installing another app.Â
I'm pretty sure screenshots used to always be png, but I just noticed that they are now jpeg. I do a lot of graphics work and want to capture as png.Â
Here there are instructions for code in Terminal. Is that really necessary? Shouldn't it just be a preference somewhere? (I will always use cmd+shift+4 to take the screenshots)
Info:
MacBook Pro, Mac OS X (10.6.8)
I am dragging and dropping a logo into Mail.app signature pane. The image is saved as a jpg, when I drag into the mail signature pane it's file name is 'PastedGraphic.tiff'. I am assuming there is file format preference somewhere that can keep the image either it's original format, or convert to a jpg, vs. a .tifÂ
Most other email clients won't display this format. .
Info:
Mac Pro, Mac OS X (10.6.8)
In 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 RelatedIs there a keyboard shortcut to merge selected cells?
Numbers '09, version 2.0.3 (332)
I just want to know if there is any way (formula) to count the numbers all the cells which are not empty in a column or row disregarding the content of the cell.
It may contain date, text or even number. I don't want to have the sum of those numbers, rather how many cells, have something in them.
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)
I'm new to iworks and have trying to figure this one out for a while. I used a template to set up financial info and calculate how much was spent on items. This was the preset formula: =SUMIF(Transactions :: $Category,A2,Transactions :: Amount)
However, I only want the sum from a particular range of dates (e.g. 9/1/09 to 9/30/09, as in cells B2:B10) so I can budget accordingly. In excel, you just grab the highlighted corner and drag it to where you want- here I can't do that and it won't let me add any more "conditions". Any idea how to remedy this? It's driving me nuts. On a side note, I am NOT a programmer so programming language will unfortunately not help unless you get VERY specific about how to do it (which you probably don't want to do).
In Numbers '08, is it possible to link cells/columns between sheets; so that in the below spreadsheet selecting an item from Column A in "Hub Dimensions" sheet in the drop down box of the "Spoke Calculator" sheet would fill out the cells in Column D of the "Spoke Calculator" sheet with data from the related cells in the "Hub Dimensions" sheet?
View 1 Replies View RelatedHiThe usual tale of an Applescript beginner getting lost but, I want to be able to search for a selected membership number within a Numbers spreadsheet, extract that member’s email address and send a message. I have managed to create a script that creates and sends the email but after several attempts I cannot work out how to start searching cells for a particular value and how to extract data from cells in the selected row.
Info:
iMac, Mac OS X (10.7.1)
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
When I get sent an excel file (.xls) I open the attachment, however if I choose Open it doesn't let me format the cells but does let me write and save. If I choose Open and Remove Macros it opens in Read Only however it does let me save whatever changes I've made but still won't let me format the cells. Is there a way to format the cells of these files that get sent to me via Entourage. Even if I save them to desktop I get the same results.
View 1 Replies View RelatedI am currently running OS X 10.6.2 on a macbook pro 5,3. How do I change to dvorak layout?
View 3 Replies View Relatedhow to change india numbers to arabic numbers?
Info:
MacBook
Pro, Mac OS X (10.6.7)
i noticed that today, when i right click on a folder (to organize for example) such options appear in numbers such as N148 instead of saying arrange by or whatever. It looks this way with most options.
Info:
MacBook Pro (13-inch Mid 2009), Mac OS X (10.6.5)
I use the Command 1, Command 2 keys in QuickTime Pro a lot to resize windows, but all of the sudden those key combos don't function at all. All Command key shortcuts seem to have left the computer.Â
Not reboot nor Repair Disk Permissions helps. Did I accidentally trigger something with a typo?
Info:
Mac Pro, Mac OS X (10.6.8), 6 GB RAM
I am running 10.6.8 on my iMac, I cannot get Pages, Numbers, iTunes to run for the last couple days. Also Word crashes as soon as I hit print.
Info:
iMac
Choose partition table, go to Options (see screenshot above). This step is often forgotten. It is probable that a new disk/flash has MBR table, as usual with PCs; GUID is for intel macs, APT for older PPC macs. If you want to exchange data with PCs, choose RAW, otherwise they will not be probably able to copy data unto this drive.So one first formats the partition, then the volume (partition, I suppose).However, the partition choices don't match the recommended formats:Â
"MBR table" is presumably "Master Boot Record" (DOS/Windows only) "GUID" is first here (OS X 10.4 or later on Intel Macs only) "APT" is probably "Apple Partition Map" (all Macs only) "RAW" is the only one recommended for both Macs and PCs,but it is not an option in the screen shot above, nor when I go to the Partition tab in my Disk Utility (v.11.5.1). How do I choose RAW (to use as storage with Macs & PCs)?(Then I should erase the volume and format it as MS-DOS/Fat.)
Info:
iMac, Mac OS X (10.6.8)
I want to clean up my mac to make it faster. I have backed up everything onto an external hardrive using time machine. Should I just start deleting everything manually or is there an easier way?
Info:
MacBook, Mac OS X (10.6.8)
How do I format an external drive (My Passport) from mac to pc (iOS Snow Leopard) without losing my data?
Info:
MacBook Pro
I want to format my Macbook Pro (Intel i7 2.7 GHz) and give it a fresh installation of Snow Leopard. I currently have two partitions on my 500 GB hard drive: the first one with the operative system, and the second one with all the backup data I want to save. Anyone can assure me that, if I install Snow Leopard again through the installation DVD, the second partition will NOT be erased? I have partial backup of the data, but not enough space for everything on my external drives. I just want to make sure that the second partition remains untouched during the installation.Â
Info:
MacBook Pro (13-inch Early 2011), Mac OS X (10.6.8)
I'm creating a Digital Cinema Package, and I need to format an external drive to Linux ex2 or ex3, and then transfer the DCP files onto it. Is there a way to do this easily from OSX? I'm fairly computer literate, but I'm mostly uneducated (and very nervous) when it comes to drive formatting, so the easier/less sketchy the better.
Info:
MacBook Pro, Mac OS X (10.6.8)
I frequently use Preview to annotate PDFs and screen shots, and every time I add a text box annotation it is formatted to center the text in the box. Is there any way to change that so that text is aligned with the left side of the box?
Info:Mac OS X (10.6)
I can't find my snow leopard disc, How do I format my MacBook Pro without it?
View 1 Replies View RelatedI don't know about you, but Snow Leopard's aurora is so much cooler. I used a program called "Desktop 2 Login" to change the default wallpaper for the login screen to a different wallpaper. Using this same program I changed it back to L's Aurora. (Still in 10.5). When I upgraded to snow leopard, the login wallpaper did not change. It is still stuck on L's aurora. I have used about every method besides Terminal, and it won't change.
View 3 Replies View RelatedI'm trying to print an Excel 2004 .xls spreadsheet file where I'm using to record attendance for the class I teach.I have my main Column A with Rows A-X and it shows up fine, I imagine because there is content in the boxes.
But I also have Columns B-L and rows A-X with nothing in their cells, but when I print it, they won't print.I need these blank because I'll check them off if the child in the first column attended the lesson. How do I make it so my many blank cells will print as well?
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)
I changed my language from English to Vietnamese. My computer went on sleep. When I tried to log on, it didn't show up the dots(for the password field). I'm thinking the language change has messed up the keyboards!I really need to log on my computer as soon as possible.By the way, I changed the language to Vietnamese VNI.
Info:Mac Pro
