Applications :: Saving As Excel In Numbers
Oct 28, 2009
I 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
ADVERTISEMENT
Nov 28, 2009
A 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.
View 2 Replies
View Related
Feb 22, 2010
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.
View 2 Replies
View Related
Mar 18, 2009
From an Excel spreadsheet I've created a graph using the chart wizard. Is it possible to save a copy of that graph as a gif or jpg file?. If so, I'd appreciate some instruction on how to do that.
View 2 Replies
View Related
May 18, 2009
I have these Numbers files but need to send them to someone who is using a pc with MS Excel. She won't be able to read the files if they are left as .numbers. The odd thing is that I have successfully saved some of the files as .xls and .xls.xls and even some as .xls.numbers.
However, I have lost data when doing some of these savings - I have been taking the .numbers file and trying to save it as .xls but when I open the newly-saved file there's nothing there. Please look at the attached snapshot of my folder structure. Can you anything in there that might be causing my problem? The red arrows are just to highlight the ones I'm particularly interested in.
View 7 Replies
View Related
Dec 29, 2009
My rows in Excel display in Numbers (1, 2, 3) instead of Alphabetical (A, B, C). Therefore I cannot type formulas for fields using A1, B2, C3, etc.
View 2 Replies
View Related
Jan 25, 2010
I have recently run a 13 page excel spread sheet for a budget on Windows and on transferring it to Numbers on my new mac, one of the formulas is not compatable. this is what I do. There is a balance figure on each of pages 2 to 13 which are then required to be transferred as a total figure in one of the columns on page 1.
This was the formula on windows: =SUM(xmas:Savings!F2)
View 4 Replies
View Related
Feb 1, 2008
Is anyone else getting this problem? When I hit Command+S in a worksheet, Excel unexpectedly quits. Very frustrating as backing up is kind of a problem.
View 3 Replies
View Related
May 18, 2010
I have some .numbers files that I need a friend to look at on her pc with Excel 2003 SP3, but it's not working for her. I have changed the extension to .xls but it's no good, as when she tries to open them they are all gobbledegook.
Here's a snapshot of the various files I have, but notice how the icons for each is different, or rather that there are two distinct designs? Some of them DO open in Excel, but some do not.
View 4 Replies
View Related
May 28, 2010
Is there a way to do this ? When I try to open any file that is password protected, I get an error that the file 'in an incompatible format' (if memory serves, I'm away from my Mac right now). I can open it fine in NeoOffice, but it never works in Number '08. I'd consider going to iWork '09 if the problem has been addressed there.
View 2 Replies
View Related
Mar 1, 2009
Is there a size limit for importing an Excel File into Numbers? The error message says the file is too large. Has this been changed in i-work 09? The file has multiple sheets that refer to each other, but i can't even open at this point. It is 3.1 MB.
View 4 Replies
View Related
Mar 19, 2009
I work in a cross platform environment (windows/mac) where we typically save common files to a shared network drive. I've found when I save a file directly from excel (as opposed to saving it locally, then copying it over) it created an invisible ._filename file in the same directory. I know it's a property/resource file for the file that I just created, but it's a little confusing for some windows users and just clutters up the share directory. Is there any way to prevent the creation of the ._filename file while still saving directly from excel?
(I'd prefer not to save locally, then move to network drive - it's cleaner for me if I can just save directly) So far, I've found that this only happens with MS Office. I've opened a sql file in textwrangler and komodo, edited it, and saved it to the network and no invisible files are created.
NOTE: this is different the the fix that apple had published regarding not creating DS_Store files - that refers to copying files from the finder to a network drive and I don't have any problems with that.
View 2 Replies
View Related
Nov 1, 2009
I have a:
Macbook Pro running Mac OSX 10.5.8
(Office 2008) Word, Exel, PowerPoint, (Iwork 2009) Numbers, Pages will not save:.
I tossed the Word Plist file and that did not work.
I have run Virus Barrier X5 and found a about 10 files with Virus 'W97M/Pinky.B' "Quarantened" them and still have the problem.
The problem started -- I think -- when I was doing heavy editing between Numbers and Word. But I don't think it is related (though who knows at this point). Without these programs I'm rendered pretty useless.
View 7 Replies
View Related
Apr 6, 2010
if you have more than one sheet in a Numbers document, is there a way to EXPORT just one sheet to Excel? There is no option to do that under the Export feature. The alternative is to copy the one sheet into a blank new numbers document then export.
View 5 Replies
View Related
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
Nov 15, 2007
The planned mid-January release of Office 2008 offers a significant overhaul of the productivity suite's look and features.
The previous segment described new features in Word 2008, with some comparisons to Apple's Pages 08. This article examines what's new in Excel 2008 and contrasts Microsoft's oldest application to Apple's newest: the Numbers 08 spreadsheet included with iWork.
View 25 Replies
View Related
Dec 6, 2008
For all you people out there hooked on Excel. Have you been able to successfully convert to Numbers or are you using both at the same time or did you try Numbers but stay with Excel??
View 12 Replies
View Related
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
Apr 24, 2009
how to compress pictures in an excel file while saving it on my mac?
View 1 Replies
View Related
Apr 30, 2012
Now that Apple have taken over our house with ipads, iphones, ipods etc , I decided to give my Dell laptop to the kids and bought a 13inch Macbook Pro and have installed Office 2011
The problem I have is with my memory stick Kingston DT Locker which I also use on Windows XP and Windows 7 - I cannot open or save Excel (xls and xlsx) and Word files (doc and docx) from/to the drive
I can copy files to the Mac, update them and then copy back to the drive
I can open pdf and jpeg files It is formatted to FAT32
Info:
MacBook Pro
View 3 Replies
View Related
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
Feb 7, 2012
I am running Lion 10.7.3 on a 2.8GHz CoreDuo iMac from 2007 and on a Macbok Air 2.13 GHz Core duo from 2010. The iMac has 4GB of RAM the Macbook has 2 GB RAM.
I run Microsoft Office 2011 on both machines. For the same file the Macbook operates normally on Word and Excel. The iMac is slow at best and when I try a Save As it hangs for up to 15 minutes brfor letting me change the FIle Name. This effectively makes it unusable.
As far as I can tell the set up of Office on both Machines is identical and I have eliminated duplicate Fonts as suggested by some posts but the problem remains. I have checked Activity Monitor and I am not getting any Page Outs so RAM does not appear to be an issue.
View 5 Replies
View Related
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
Feb 6, 2009
I am searching for a plugin, software or a solution for a situation I have with an Excel/Word Mail Merge.
It's a law firm we specialize in DUI/DWI and Reckless Driving defense. We subscribe to a data collection service that pulls data from various court systems around the state. We are then given this data by jurisdiction. The Excel files we receive come with 2 workbooks in one file for Traffic and Criminal arrests data with name, address, reason for arrest, etc, etc.
What I have been doing is opening each Excel file and copying and pasting into a new worksheet only grabbing the DUI and Reckless driving arrests because tis is all I am needing from the various files. I then save the new workbook and do a mail merge with Word from this newly created workbook.
Now my question is there such a plugin or software that will combine all the Excel files I receive from the Data collection house and then be able to filter out only the DUI and Reckless Driving arrests to a single Excel Workbook?
View 6 Replies
View Related
Apr 13, 2010
1. Turned the List Manager on by accident in Excel. Can't figure out how to turn it off now. I am using Excel 2004, and a MAC mouse - so no right-clicking for me...
2. How do I move columns in Excel? I select the column on top, but then try dragging it to a place I'd like it to move, but nothing happens. How do I do that?
3. General Mac Word/Excel question - how do I get to use "Home" and "End" buttons? When I hit them I simply jump somewhere, but not to the beginning or end of the paragraph. I have a MAC keyboard with the "Home" and "End" buttons along with the "Help", "Delete", "Pg Up" and "Pg Dwn" keys - basically it looks a lot like a PC keyboard...
View 1 Replies
View Related
Oct 21, 2010
I have been asked to do a project at work in Excel. I am keeping track of around 7,000 properties all over the United States. My boss wants to know a lot about each one. I am really struggling with the weather part!! I need to somehow pull the temp and if its snowing or raining from the internet into excel. I have all the addresses and zip codes for each property. I was thinking i could write a formula that looks at an RSS feed or website (like yahoo or Google weather) based on the zip code of the address. I could also write the formula that pulls the weather to excel then VLOOKUP the zip. Does anyone have any ideas about this?? I am not sure what to do!!
View 3 Replies
View Related
Oct 21, 2010
I have been asked to do a project at work in Excel. I am keeping track of around 7,000 properties all over the United States. My boss wants to know a lot about each one. I am really struggling with the weather part!! I need to somehow pull the temp and if its snowing or raining from the internet into excel. I have all the addresses and zip codes for each property. I was thinking i could write a formula that looks at an RSS feed or website (like yahoo or Google weather) based on the zip code of the address. I could also write the formula that pulls the weather to excel then VLOOKUP the zip. Does anyone have any ideas about this?? I am not sure what to do
View 1 Replies
View Related
May 22, 2010
I recently purchased my first MAC with Excel for Mac 2008. I am unable to open any files created in it on my PC which has Excel 2003. Apple is of no help. They had assured me of compatibility at purchase citing the new open format. The MAC Excel 08 file won't open on the MAC on which is was created with their Numbers program either.
View 4 Replies
View Related
Nov 10, 2009
When I send my .xls files from my Mac (Office 2008) to my boss's Windows machine (Office 2003), he gets an error message when he attempts to open the excel spreadsheet: Excel has encountered an error and must shut down. I've sent files to other computers and not had a problem, and my boss has received other excel files and been able to open them. So it must be something between these two machines/softwares that is affecting it. Any suggestions or ideas? I can add any additional info you need.
View 2 Replies
View Related
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
