Use Paste Special In Excel Code Text And

Job done. When I try that with the clipboard from Numbers the Paste special window offers me options of PDF, Picture, HTML, Unicode Text and Text.

Here is a Numbers document with a formula in column C Select and copy column C.

If your profile is up to date (and you are using Numbers 09) the menu command is Paste Values not Paste Formula Results Ian.

Or you can do that yourself after opening the document with Numbers on your Mac.

Then you will be able to open the exported document with Excel.

Some formatting and other features may be lost but it seems to work reasonably well in most cases.

If you are just transferring some data, not a whole document, sometimes its easier to just copy-paste between the two applications.

Unfortunately Im away for the next month and unable to try the solution until I return.

Apple may provide or recommend responses as a possible solution based on the information provided; every potential issue may involve several factors not detailed in the conversations captured in an electronic forum and Apple can therefore provide no guarantee as to the efficacy of any proposed solutions on the community forums.

Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site.

All postings and use of the content on this site are subject to the.

How To Use Paste Special In Excel For Mac