paste only visible numbers in Excel

Question

_{Thursday, May 15, 2014 6:43 PM}

How would I copy and paste "1.41999995708465", which appears on my screen as "1.42", to actually be "1.42"?  I am comparing the result of a calculation in one column to a rate table in another column.  Both are actually 1.42. In other words, when using two decimals, they agree.  But, due to Excel's extra decimals, I cannot express that fact.  This challenge extends to many rows of data, naturally.

Doug in York PA

Douglas R. Eckert

All replies (3)

_{Friday, May 16, 2014 11:44 AM ✅Answered}

Thank you, George!

Doug in York PA

Douglas R. Eckert

_{Thursday, May 15, 2014 7:19 PM}

How about this:  if your data is in A1 you can round with this in B1=ROUND(A1,0) then copy and paste that?

A "thank you" goes out to Old Chippy on the Excel Forum.

Doug in York PA

Douglas R. Eckert

_{Friday, May 16, 2014 7:28 AM}

Hi,

The Number precision of Excel is 15 digits. If we set the cell format as Number, we may increase decimal (Click Home tab>Number group).

Next, the ROUND function rounds a number to a specified number of digits.

Syntax: ROUND(number, num_digits)

The ROUND function syntax has the following arguments:
number    Required. The number that you want to round.
num_digits    Required. The number of digits to which you want to round the number argument.

Quote from:

http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP010342495.aspx

http://office.microsoft.com/en-gb/excel-help/round-function-HP010062455.aspx

Regards,

George Zhao
TechNet Community Support