Copy, Paste special, Values

  • Thread starter Thread starter Fritz
  • Start date Start date
F

Fritz

The result of a simple formula should be a whole number
with no decimals. However, when I used Copy, Paste
Special, Values, excel returns decimal values that are
slightly above or below the expected whole number. For
example, when A1 contains the value 49.931, copying the
value from the formula (A1-49)*1000 yields
930.999999999997 when the actual result should be 931. Any
explanation would be appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Paste special - Values 1
I can't copy and paste equations 0
Paste Special Values 2
Copy and paste special 2
Paste Special Formula Multiply feature doesn't work anymore 2
I cannot paste values as numbers 3
copy and paste the cell with formula ="1" 3
Excel Need Countifs Formula Help 0

Back
Top