Download Numbers for Mac from the Mac App Store Download Numbers for iOS from. Or import and edit Excel spreadsheets right in Numbers. Most popular Excel features.
By You expect Excel for Mac 2011 to open Excel files, of course, but the program can do more than that. You can actually open, work on, and save a file in several formats. Choose File→Save As and then click Format to open the pop-up menu. Excel can open and save in the formats listed in this Format pop-up menu.
You have several options for file formats besides Excel’s default (.xlsx) format:. Excel Template (.xltx): Saves the workbook as a template, which you can open in the My Templates section of the Excel Workbook Gallery. You can also open templates by choosing File→Open and selecting Excel Templates from the Enable pop-up menu. This format does not have macros and is another open XML format.
Excel Macro-Enabled Workbook (.xlsm): Workbooks in this XML format contain Visual Basic for Applications (VBA) programming language code, or Excel 4.0 macro code. When opening this format file, Excel displays a prompt asking whether you want to remove the macros contained in the file.
The default is Disable Macros. You must instead click Enable Macros if you want macros to run. Excel Macro-Enabled Template (.xltm): The same as.xlsm, except this is a template. The macro warning dialog displays when you open a workbook in this format, and you must click Enable Macros if you want macros to run. Excel Add-In (.xlam): Saves a macro-enabled workbook as an Excel add-in. Excel Binary Workbook (.xlsb): This is the most compact file format, and is recommended for large files.
This format doesn’t conform to open source standards. Comma Separated Values (.csv): Saves a worksheet data table as text separated by commas. This format is text only.
All other content is discarded. Web Page (.htm): Save the workbook in a format that Web browsers understand and can display.
Excel creates a file in HTML format, along with a supporting folder. Upload both the file and folder to a Web server if you want to share your workbook via the Internet. Excel can open and save Web pages in HTML (HyperText Markup Language) format and do great things with Web tables and data from the Web, but don’t uninstall your HTML (Web page) code editor.
Excel can’t replace that.
I'm running Excel for Mac Version 15.14, OSX Yosemite 10.10.5, and using an Office 365 subscription. I have multiple cells in a spreadsheet that are in the wrong phone number format (long story). The phone numbers in the spreadsheet are currently in this format 12-345-67890, instead of 123-456-7890. I have tried using a custom number format (###-###-####), the Special Phone Number format, and the Custom format they have for phone numbers (.