Paste only two decimal places

  • Thread starter Thread starter Ozzie
  • Start date Start date
O

Ozzie

Taking a huge file with lots of formulas and pasting it to
another spredsheet. When I paste special / values I get
more then 2 decimal places. I'm sure that I've read here
that it is possible to paste special with only two decimal
places. Can someone "jog" my memory?

TIA


Ozzie
 
if you have it setup the way you want to, how about pasting special
also.

i remember reading somewhere, that someone had it in an add-in, bu
can't remember where. maybe check ASAP Utilities.

HT
 
One way, but don't save the source file when you are done, (else you willl lose
data), is to choose Tools / Options / Calculation / Precison as displayed, and
as long as your data was formatted to 2dps, then it will only be 2dps when you
paste it. Then close the source file without saving and change the setting back
to 'not' being enabled
 
Back
Top