Description

This article is from the Spreadsheets FAQ, by Russell Schulz casfaq@locutus.ofB.ORG with numerous contributions by others.

10.5 What's this about the 15 digit numbers that return 0.64 or 1.28? (spreadsheets: Excel)

according to Microsoft, the problem numbers are:

> 140737488355328   = 2^47
> 281474976710656   = 2^48
> 562949953421312   = 2^49

> multiples of ten also cause problems, such as 1.40737488355328

see http://support.microsoft.com/support/kb/articles/q128/6/50.asp
see ftp://ftp.microsoft.com/deskapps/excel/kb/q128/6/
see http://support.microsoft.com/support/kb/articles/q128/3/32.asp
see ftp://ftp.microsoft.com/deskapps/excel/kb/q128/3/

 

Continue to:

• prev: 10.4 Why do I get "File format no longer supported"? (spreadsheets: Excel)
• Index
• next: 10.6 How can I read Excel files without Excel?

Share and Enjoy

Tags

business, spreadsheets, Excel, Quattro, Lotus 1-2-3, free, open source, commercial, tab delimited, csv, formula, macro