Errors when copying
Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance
Date: Wed, 21 Apr 2004 15:01:45 -0700
When copying birth dates in the format of month/day/year into another
worksheet, somehow the numbers are increased by several digits. Is this a
glitch in Excel for Mac, or is this something that can be fixed?
Relevant Pages
- Re: Unacceptable floating point errors
... which Excel would display as 0.010...0 to 15 significant digits. ... But I do not mean to suggest that Excel is flawed for not doing so in its ... The exact internal representation of the constant 0.01 is ...
(microsoft.public.excel.misc) - Re: INT defect: Please try this on 2007 for me
... Not that I would object to a calculation option that would do just that, namely: force the result of all formulas to be rounded to 15 significant digits, not unlike the "Precision as displayed" option, but more generally applied. ... That would legitimatize some of the heuristics that Excel has implemented to try to ameliorate the aberrations due to binary floating point arithmetic. ...
(microsoft.public.excel.worksheet.functions) - Re: Text formatted cells displaying numbers in scientific format
... It is just Excel trying to be helpful. ... When it 'sees' a large number it uses scientific format since ... I accept that Excel can't handle numbers greater than 15 digits and your ... string was 16 digits or more to be converted to a scientific value. ...
(microsoft.public.excel) - Re: 16th digits and following replaced by zeros
... As you have noticed Excel handles only 15 digits of precision. ... The reason is that Excel, like many other computer programs, uses ...
(microsoft.public.excel.misc) - Re: Is this a known bug in Excel ???
... Excel and almost all other software does math in binary, ... using the IEEE standard for double precision storage, ... decimal digits (see Help for "Excel specifications and limits" subtopic ... to the sum of the binary approximations to your numbers: ...
(microsoft.public.excel.misc) |
|
