Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
nth nth is offline
external usenet poster
 
Posts: 1
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,059
Default 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.


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,819
Default 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?


  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 229
Default 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?
  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6,582
Default 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?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
excel 2007 850*77.1=100000 Kenchr Excel Discussion (Misc queries) 18 October 22nd 07 08:56 AM
answer =850*77.1 formula in excel 2007 is 100000 , WHY? piknik Excel Worksheet Functions 6 October 22nd 07 08:55 AM
850*77.1=100000 ?! (Excel 2007) 陳上德 Excel Discussion (Misc queries) 4 October 22nd 07 08:53 AM
Sheet is not shown in 2007 Simon Minder Excel Discussion (Misc queries) 5 February 23rd 07 12:54 PM
Sheet is not shown in 2007 Simon Minder Excel Discussion (Misc queries) 0 February 1st 07 08:47 AM


All times are GMT +1. The time now is 07:58 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"