Applications :: How To Convert Numbers Into Excel Files
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.
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.
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)?
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.
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.
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)
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.
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.
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.
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.
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.
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"
I have 5000 contacts stored in Excel sheet and I am using Office 2010. It’s such a cumbersome task to copy each contact in Gmail for bulk emailing. Is there any online tool available through which I can convert all these contacts into single VCF file?
I'm downloading different files into excel (some tab delimited, some csv, some xls) from different places and they all open in excel with incredibly weird formatting. Basically the separation of each column makes no sense. When other people download the same exact files, their files appear normally, with each category in a different column. So there's something going on with my excel.
When I download a credit card statement, for example, it comes out like this:
"02/03/2010$18""82USPS 35960795520803QPS NEW YORK XXXXXXXXXXXXXX48(Standard Purch)"
With the quotes showing the columns... so the date and half of the price are in one column and the cents from the price and the vendor and the last four digits in the second column.
Being a relatively new Mac user, I'm not sure what the best freeware would be for what I want to do, and I don't want to download twenty different programs before I find the right one. So, I'm looking for recommendations.
1) I want to find a program that lets me easily convert .wma files to .mp3's. 2) I also want to find a free, simple program that allows me to unzip .rar files. (This is another case with mp3's, except I have twenty songs zipped into one, and can only play them with VLC RAR-Loader.)
I know it has been talked a lot about ripping and converting Blu Ray DVDs. Without a doubt Windows Users have a lot more apps to choose from - as always. Well, as I looked thru dozens of forums and tried out a lot - I still have no answer to my problem. I want to use m2ts - video files from Blu Ray Disks, that I copied onto a harddrive and convert them into 1920x1080 px MOV files - so that I can work with them later on. My interest is not to work with a 1to1 mkv-version of the whole film and sound and subtitles. I just want to convert the copied file to work with it in a video editing program. Some Apps seem not to offer 1920x1080 output file size. Is this possible without an complete Blu Ray Rip with Tools such as Pavtube etc? And can one only convert from an Original BD Disk?
My System is a MacBook PRO 10.5.8 // 2.2 GHZ Intel DUO// 2GB Ram
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.
What FREE Mac Application should I use to convert .MP4 video files to .SWF video files? I doesn't matter to me if they are good quality in the end because all of the videos are going to be on my MP3 player's screen.