How to copy/paste cell text (not the formula)

**slavezero** · 09-24-2009, 05:50 PM

I have a drop down list. When I choose something from the list, it creates a description (text) in the next cell. I need to be able to copy/paste the text from the cell, but it will only let me choose the formula instead. Any ideas??

**shg** · 09-24-2009, 05:55 PM

Copy the cell normally, select where you want it to go, then Edit > Paste Special, tick Values

**garbisrobert** · 12-30-2012, 04:25 PM

Is not that simple, i copy data from website (with macro and web query), and formats as scores (0-1, 2-0, etc) is stored by excel as DATE format. When i copy/paste as value, show a number like 40906. All i want is to have score copy corectly from that website through web query.

**Ace_XL** · 12-30-2012, 04:30 PM

Maybe..

Copy --Paste special -- values--then paste special -- formats

**protonLeah** · 12-30-2012, 07:56 PM

@garbisrobert,
Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.