Convert to 1000's or Lacs

If you have large set of data in the units and you want to quickly convert into 1000’s or lacs or any denominator, use divide function in Paste Special command,

 

The same applies if you want to multiply too….