View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
joeu2004 joeu2004 is offline
external usenet poster
 
Posts: 2,059
Default Why does Excel INT(x) behave like ROUND(x,0) for 10^14 andhigher?

On Jan 18, 12:02*pm, Jerry W. Lewis
wrote:
WAG as to what MS was thinking: If you ask Excel to round a number, you
probably will evaluate its [behavior] based on what you can see (documented
15 digit limit). *Why they extend that thinking to INT, TRUNC, etc is a
mystery.


And even more of a mystery since, as you say, 1E+14+0.5 is not even
displayed as 100000000000001 (if I counted the zeros correctly <g) in
Excel 2003, when formatted as Number.

BTW, I should have noted that I am, indeed, using (Office) Excel 2003.

Anyway, thanks for your comments. I was hoping that you, especially,
would have an answer for me. Oh well....