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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
copy-past without formala
- Thread starter daveask
- Start date
You can do this by doing a double Paste Special. Copy as you would normally do and then use a right click to paste, but choose Paste Special... Pick the Values option. Then right click on the same cell, choose Paste special... and choose formats.
Mike
Mike
- Status
Similar threads
- Locked
- Question