The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
 |
Newsgroups: microsoft.public.excel
From: mega...@gmail.com
Date: Mon, 24 Sep 2007 20:11:07 -0700
Local: Mon, Sep 24 2007 11:11 pm
Subject: Re: Bug in Excel 2007
This is simple rounding error. Down at the hardware level of PCs,
when working with floating point numbers, you are only guaranteed a number of significant digits (varies depending on the size of the data type). In this case, your numbers are good up to 7 digits (NNNNN.NN), which fits with the double data type in C. On Sep 23, 9:25 am, "Dana DeLouis" <ddelo...@bellsouth.net> wrote: > I also see that Excel 2007 still has this over 10+ year bug still in it:
> =40000.223 > Such numbers are converted to: > =40000.2229999999 > -- > "Molham Serry" <mse...@contact.com.eg> wrote in message > news:834DAE15-EE9C-4996-A63B-2C443F09F604@microsoft.com... > > Simply when you try to multiply 850 by 77.1 excel display the result to be You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
| |||||||||||||