Question: how to copy and paste numbers without decimals in excel?
Answer: Hi, Format the Cell B1 to "No Decimal" in Format Cells, Number Option. Copy from the source and use Paste Special-Values. By this, Number in the cell will be displayed as "3"...and in the formula cell you can find "2.5666"...