If you're talking about the Excel 2007 bug (which doesn't have a darn thing
to do with Vista) it's a display bug. It mistakenly displays 100,000
instead of 65,535. If you reference that result in another cell with
another function, the correct result is shown.
And Microsoft knows about it and a fix is already being tested.
If you're talking about the Excel 2007 bug (which doesn't have a darn
thing to do with Vista) it's a display bug. It mistakenly displays
100,000 instead of 65,535. If you reference that result in another
cell with another function, the correct result is shown.
'As long as you handle the numbers within Excel, they work properly and
simply display incorrectly.'
And then goes on later....
'A common method is to export to a CSV file which can then be imported
into another program (often a database which cannot read and write to
Excel files directly). CSV files will also carry the incorrect display
figure instead of the underlying stored value.'
Apparently using ROUND can also make the bogus number stick.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
