Bookmark and Share

Enter your email address:

Delivered by FeedBurner



Home Page













Subscribe here
Add to My Yahoo!
This page is powered by Blogger. Isn't yours?

Host your Web site with PureHost!


eXTReMe Tracker
  Web http://www.klippert.com



  Wednesday, November 04, 2009 – Permalink –

Paste is Special

Versatile functions


If the data you brought into Excel comes through as text rather than numbers, Paste Special can fix it.

  1. Go to an empty cell.
  2. Copy it
  3. Select the "corrupted" data.
  4. Go to Edit>Paste Special and choose Add.
This works better than multiplying by one. Empty cells remain empty


What's So Special About "Paste Special"?

Excel Paste Special function

Pasting Using Paste Special



[Edited entry from 10/27/2006]

See all Topics

Labels:


<Doug Klippert@ 3:04 AM

Comments: Post a Comment

Links to this post:

Create a Link