# Floating Point

Kathleen Bell
Guest
Posts: n/a

 9th Jan 2006
Years ago I heard about the way Excel stores numbers. I wrote it off as
something accountants would never have to deal with since we weren't dealing
with high precision numbers. Well...

This past week I tried to upload a journal entry that had about 15K lines.
The computer rejected it as not balancing. In the ninth and tenth decimal
places there was a 15. We tried everything. It became a "class project".
We tried rounding up, rounding down, just plain rounding, truncating. We
copied as values, copied as text and then recopied as numbers. Finally we
found a website that talked about the floating point, something which
something that sort of came out of the recesses of my memory. There was no
other explanation.

I split the journal entry into three and somehow the new combination of
numbers got rid of the phantom number way out there and they went through.

JE McGimpsey
Guest
Posts: n/a

 9th Jan 2006
take a look here:

http://www.mcgimpsey.com/excel/pennyoff.html

In article <(E-Mail Removed)>,
"Kathleen Bell" <(E-Mail Removed)> wrote:

> Years ago I heard about the way Excel stores numbers. I wrote it off as
> something accountants would never have to deal with since we weren't dealing
> with high precision numbers. Well...
>
> This past week I tried to upload a journal entry that had about 15K lines.
> The computer rejected it as not balancing. In the ninth and tenth decimal
> places there was a 15. We tried everything. It became a "class project".
> We tried rounding up, rounding down, just plain rounding, truncating. We
> copied as values, copied as text and then recopied as numbers. Finally we
> found a website that talked about the floating point, something which
> something that sort of came out of the recesses of my memory. There was no
> other explanation.
>
> I split the journal entry into three and somehow the new combination of
> numbers got rid of the phantom number way out there and they went through.

=?Utf-8?B?am9ldTIwMDRAaG90bWFpbC5jb20=?=
Guest
Posts: n/a

 10th Jan 2006
"Kathleen Bell" wrote:
> Finally we found a website that talked about the
> floating point, something which something that sort
> of came out of the recesses of my memory. There
> was no other explanation.
>
> I split the journal entry into three and somehow the
> new combination of numbers got rid of the phantom
> number way out there and they went through.

Do you have a question? Perhaps it would help to read
the following KB articles:

http://support.microsoft.com/kb/214118/en-us
http://support.microsoft.com/kb/78113/en-us
http://support.microsoft.com/kb/57298/en-us

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post StargateFan Microsoft Excel Programming 2 5th Dec 2005 11:26 PM Carey Frisch [MVP] Windows XP Help 0 17th Sep 2004 08:19 PM =?Utf-8?B?UG9ydGVyaG91c2U=?= Windows XP Help 0 17th Sep 2004 08:13 PM =?Utf-8?B?a2F0dGJvbzIwMDQ=?= Windows XP Help 2 17th Jun 2004 05:07 AM Dirk Desart Windows XP Help 0 31st May 2004 12:19 AM

Features