Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel paste special missing options

Status
Not open for further replies.

jlockley

Technical User
Nov 28, 2001
1,522
US
Frequently but not consistently the paste special interface on Excel only provides the choices of Unicode or text This can happen with the same data on the same spread sheet. Skype for Firefox is not installed, Excel has no add-ons and has been tested in Safe Mode. All data is in numeric format.
This happens too, for the sake of checking, with figures cut and paste directly from the calculator. (which then were reformatted as numbers). It happens whether Firefox is open or not. Sometimes copying the data into a new sheet enables paste special for a bit, but on returning to the sheet I find it no longer functional.
For instance these negative numbers (It does not matter if the numbers are negative or positive, if they are in brackets or have minus signs showing they are debits.)
(0.47)
(1367.15)
2145.13
2818.48
(7.42)
(19.51)
Any clues?

 
Are there images in the cells? Use the Select Objects Mode and see if anything is selected.
 
Test if you still have data from the same workbook in the office clipboard. To do this, open word and do paste.

combo
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top