ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   why result 77.1 * 850 shown 100000 in excel 2007? (https://www.excelbanter.com/excel-discussion-misc-queries/176019-why-result-77-1-%2A-850-shown-100000-excel-2007-a.html)

nth

why result 77.1 * 850 shown 100000 in excel 2007?
 
Result 77.1 * 850 shown 100000 in excel 2007 but the value of result cell is
correct !!!
Do you Know why?

joeu2004

why result 77.1 * 850 shown 100000 in excel 2007?
 
On Feb 7, 11:00*pm, nth wrote:
Result 77.1 * 850 shown 100000 in excel 2007 but the value of
result cell is correct !!! Do you Know why?


Old news! Take a look at the following discussions in Sep/Oct last
year (2007). I hope the links are clickable. Pay special attention
to postings by Jerry Lewis in those threads.

http://groups.google.com/group/micro...5182d3e19159f7

http://groups.google.com/group/micro...391852f13142ec

HTH.



Bob I

why result 77.1 * 850 shown 100000 in excel 2007?
 
Description of the Excel 2007 hotfix package: October 9, 2007
http://support.microsoft.com/kb/943075

nth wrote:

Result 77.1 * 850 shown 100000 in excel 2007 but the value of result cell is
correct !!!
Do you Know why?



iliace

why result 77.1 * 850 shown 100000 in excel 2007?
 
On Feb 8, 2:00 am, nth wrote:
Result 77.1 * 850 shown 100000 in excel 2007 but the value of result cell is
correct !!!
Do you Know why?


How is it that so many people have stumbled upon that specific
combination when there are so many others that produce this
irregularity? Is there something that costs $77.10 that everyone
needs 850 of?

Jon Peltier

why result 77.1 * 850 shown 100000 in excel 2007?
 
I suspect there are a lot of copycat sightings, people trying to criticize
this already fixed problem (when there are others deserving of attention).

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"iliace" wrote in message
...
On Feb 8, 2:00 am, nth wrote:
Result 77.1 * 850 shown 100000 in excel 2007 but the value of result cell
is
correct !!!
Do you Know why?


How is it that so many people have stumbled upon that specific
combination when there are so many others that produce this
irregularity? Is there something that costs $77.10 that everyone
needs 850 of?





All times are GMT +1. The time now is 04:53 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com