Thread: Another Stupid Excel Question
View Single Post
Old 09-29-2007, 07:51 AM   #10
JWBear
Worn Romantic
 
JWBear's Avatar
 
Join Date: Feb 2006
Location: Long Beach California
Posts: 8,435
JWBear is the epitome of coolJWBear is the epitome of coolJWBear is the epitome of coolJWBear is the epitome of coolJWBear is the epitome of coolJWBear is the epitome of coolJWBear is the epitome of coolJWBear is the epitome of coolJWBear is the epitome of coolJWBear is the epitome of coolJWBear is the epitome of cool
Quote:
Originally Posted by Ghoulish Delight View Post
Yup. It's apparently only a display problem, not really a math problem. If you feed the result of such an equation as input to another equation, it works fine. But if your final answer to be displayed is either 65,535 or 65,536 (or apparently within a few decimal places thereof), the engine that converts it into displayable text loses its brains and displays "100,000" as the answer.
Ok, thanks. I was worried that it might open a portal to another plain of existence or something.
__________________
Unrestrained frivolity will lead to the downfall of modern society.
JWBear is offline   Submit to Quotes Reply With Quote