The Microsoft Excel COMPLEX function converts coefficients (real and imaginary) into a complex number. The complex number can be in either form, x + yi or x + yj. The COMPLEX function is a built-in function in Excel that is categorized as an Engineering Function. Functions - Use built-in Excel functionality, such as =AVERAGE to perform operations easily on your data. =DAYS helps you calculate the number of calendar days between two dates. I like to use the DAYS formula when I'm looking at the amount of time between today and a future event, for example.

Hi Dennis, Numbers 3.2. Menu > File > Export To > Excel. That will create an Excel copy on your machine.

Send it to your Excel friends. They will find that every object (table, graph, text box) will appear on a separate sheet in Excel. That just how it works. Numbers will open an Excel document and you can edit. But be aware that continued conversion to and fro between Numbers and Excel is not perfect. Glitches will build up. If your Excel friends blame Mac, tell them that the problem belongs with Microsoft.

Excel does not in any way recognise a Numbers document! Regards, Ian. Hi Dennis, Numbers 3.2.

Menu > File > Export To > Excel. That will create an Excel copy on your machine. Send it to your Excel friends. They will find that every object (table, graph, text box) will appear on a separate sheet in Excel.

That just how it works. Numbers will open an Excel document and you can edit. But be aware that continued conversion to and fro between Numbers and Excel is not perfect. Glitches will build up. If your Excel friends blame Mac, tell them that the problem belongs with Microsoft.

Excel does not in any way recognise a Numbers document! Regards, Ian.

Hi mg, What version of Numbers are you using? What version of OS X? Numbers 2 (Numbers '09) under OS X El Capitan no longer supports Share > Send via Email. (This may have been broken in OS X Yosemite.) You must Share > Export > Excel. Or File > Export > Excel. Save the exported Excel document in a temporary folder Then in Mail, attach that Excel document to a message.

In Numbers 3.6.2 Share > Send a Copy > Mail > Choose Excel Mail will open a new message containing the exported Excel document. Or File > Export to.

Without the distraction of personal finance features, it is easier to learn to use QuickBooks Simple Start. Look and Feel: Because QuickBooks Simple Start focuses only on helping you with small business accounting activities, it has a simpler interface than Quicken Home & Business and is easier to navigate.

Save in a temporary folder and attach to an email message. Regards, Ian. ' When I convert the file to excel from Mac' More precisely 'When I convert the file to excel from Numbers on a Mac' Numbers is not a clone of Excel.

The two applications have different feature sets, including different means of handling images and other objects. When you Export a Numbers file to Excel, Numbers translates that file into something the Excel can read.

Numbers features not supported in Excel or supported in a different manner will display differently when opened in Excel. When you Open an Excel file in Numbers, Numbers translates the Excel file to Numbers' native format. Excel formulas not supported in Numbers are dropped, and the last results calculated by the formula is imported to Numbers. If you are sending documents back and forth between your Mac and MS Excel on someone elses PC, Numbers is not the best tool to use. The best would be a current version of MS Excel for Mac, for which.xlsx is the native format. Second choice would be. Both of these mimic the functions of MS Excel more closely than does Numbers, and therefore provide more accurate matches to Excel files.

The links will take you to their respective download sites. Both are free to download and use, although both do request donations to support further development. Regards, Barry. Apple Footer • This site contains user submitted content, comments and opinions and is for informational purposes only.