View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob I Bob I is offline
external usenet poster
 
Posts: 2,819
Default Why in excel does 41202.80721 get changed to 41202.8072099999

To simplify it's caused by the limits of binary storage and decimal
representation and the conversions between the two.

Jamo12t wrote:

Why do certain values in excel get converted such as the above or 41141.51430.

Thanks

James