Applications :: How To Convert Numbers Into Excel Files
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 (Posted: May 17, 2009)
Sponsored Links:
Related Forum Messages for Mac:
Numbers 09 :: Numbers Files Imported From Excel Are Very Large?
I maintain a few moderately large Excel files. A typical file may have ten to forty tabs and each tab has 100 rows and 30 columns, let's say. They normally range from 1MB to 5MB although I have a large file has has reached 30MB. I would like to use Numbers but every time I import an Excel file into Numbers, and then save as a .numbers file, the resultant file is always much larger than the original Excel file. I tried this again today after cutting down a 5MB Excel file to 1.5MB but the Numbers equivalent was three times larger than the reduced Excel file. Information: Mac Pro, iMac-G5, iMac-Intel, iPhone Mac OS X (10.6.3)
Posted: Apr 18, 2010
View 4 Replies!
View Related
Applications :: How To Convert Vcards To Excel
I have an address book-created VCARD list that I need to get into some form of comma delimited or Excel. I have not touched WINDOWS in 9 years so please don't suggest anything that has anything to do with Windows. I am a MAC user. Being forced to use OFFICE in this Word/Excel/powerpoint world I attempted to do something through Entourage. After I wasted an hour with that, I posted this on this forum. If anyone knows of any program that will allow you to create an address list so a MAC user who has created vCARDS in address book can share with Excel users, let me know.
Posted: Jul 4, 2009
View 8 Replies!
View Related
Numbers 09 :: Is Excel Files Encrypted
Attempted to open an un-encrypted .xls file, however, the alert said it was encrypted and couldn't be opened. Opened no problems (no passwords requested) w/ a neighbors Excel program and had them re-save as .xls and .xlsx and re-name it. Still says its encrypted... Information: MacBookPro Mac OS X (10.6.2)
Posted: Feb 25, 2010
View 3 Replies!
View Related
Numbers 09 :: Opening Excel Files With Pop Up Menus
I have a few Excel 2003 spread sheets that contain pop-up menus inside various cells. When I open the Excel files using iWork09 my pop-up menus are gone and I get a waring saying the cell pop-up menus are no longer available. Information: 17" Macbook Pro Mac OS X (10.6.2) Excel 2003 & Numbers (iWork09)
Posted: Jan 25, 2010
View 2 Replies!
View Related
Numbers 09 :: Opening Excel XLS Files - Document Encrypted
I have Mac OS 10.6.2 on my MacBook using Numbers '09. A windows excel pc user sent a xls file. When I try to open this file on my MacBook with Numbers is get message "The document is encrypted and can't be opened." The windows user says the file is not locked/protected/encrypted. I have opened other xls files ok. Information: Macbook Mac OS X (10.6.2) Numbers 09
Posted: Dec 27, 2009
View 1 Replies!
View Related
Applications :: Saving As Excel In Numbers
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)?
Posted: Oct 27, 2009
View 3 Replies!
View Related
Applications :: Rounding Numbers In Excel?
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.
Posted: Nov 27, 2009
View 2 Replies!
View Related
Applications :: Using Excel Formula In Numbers
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.
Posted: Feb 21, 2010
View 2 Replies!
View Related
Applications :: Excel To Numbers - Fx Formula Not Compatible
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)
Posted: Jan 24, 2010
View 4 Replies!
View Related
Applications :: Opening A Numbers File In Excel Won't Work With Extension Of .xls
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.
Posted: May 17, 2010
View 4 Replies!
View Related
Numbers 09 :: Copying Columns Of Data From Excel To Numbers?
I have an annoying problem by copying columns of data from Excel to Numbers. For example, if in Excel one column of data has 1100 numbers, and you click to choose this entire column, and copy it. Then when i open the Numbers, and choose "Blank" sheet, it only has 45 rows in default. And once I click to choose "paste", the copied data can only paste the first 45 in the Numbers. Also, if you have more than 1100 rows in Numbers by manually drag the bottom left icon, it will repeat to fill the rest of extra rows from the start. I don't quite understand why Numbers cannot do it like Excel, no matter how many rows your table has, just paste all of the copied data exactly. Is there anybody here who can help me out for this? Information: MACBOOK A1278 Mac OS X (10.5.6)
Posted: May 6, 2010
View 4 Replies!
View Related
Numbers 09 :: Look And Font Of Excel Spreadsheets In Numbers?
I am a new convert to apple. I receive a lot of schedules as excel spreadsheets. When I print them from my PC everything looks fine. Borders, fonts etc. But when I use iworks numbers everything looks bigger. The spreadsheet prints onto 4 pages and it fills up all the borders. Is this a problem of fonts? page formatting? Information: macbook pro Mac OS X (10.6.4)
Posted: Oct 25, 2010
View 1 Replies!
View Related
Applications :: Unable To Download Files Into Excel?
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.
Posted: Mar 30, 2010
View 2 Replies!
View Related
Applications :: Cannot Format Cells In Excel Files Sent Via Entourage
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.
Posted: Jun 9, 2009
View 1 Replies!
View Related
Applications :: Cannot Save - Edit - Open Files In Microsoft Excel
I'm getting tons of issues opening, saving, and editing files in Microsoft Excel. My checkbook is basically unrecoverable. Files saved give errors that they are read only or the same name as a read only file, despite not being read only. Opening Quote: Finance_Spreadsheet.xls cannot be accessed. The file may be read only or you may be trying to access a read-only location. Or the server the document is stored on may not be responding......
Posted: Apr 3, 2010
View 10 Replies!
View Related
Applications :: Preventing Invisible Files When Saving Directly From Excel To Network Drive
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.
Posted: Mar 18, 2009
View 2 Replies!
View Related
Applications :: Using Mac Excel - Merge/Filter/Extract Into A Single Excel File?
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?
Posted: Feb 5, 2009
View 6 Replies!
View Related
Applications :: Turning List Manager In Excel Off / Moving Columns In Excel?
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...
Posted: Apr 12, 2010
View 1 Replies!
View Related
Applications :: Handbrake Will Not Convert .dv - .avi Files / Sort This?
I need some help to convert .dv and .avi files to ipod touch compatible files using handbrake. When I try to choose either file type as the source file it just says 'no valid title found'. The .dv file is a clip shot with my video camera and imported onto my mac using imovie, then saved as separate full quality file, in order to have a separate file that is not sitting in imovie. The .avi file is a downloaded movie. Both movies play fine in quicktime player and VLC player. The Handbrake program does work as I have successfully converted a file ripped from a dvd using mactheripper. I am surprised that I can't get it to work, as other threads on this forum recommends handbrake as the best software for video conversions for ipod.
Posted: Aug 30, 2009
View 6 Replies!
View Related
Applications :: Excel: Pulling Weather Into Excel Spreadsheet?
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!!
Posted: Oct 20, 2010
View 3 Replies!
View Related
|
TRACKER
