Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Bewilder
 
Posts: n/a
Default Mistery digits on excel

I have created a chart with 2 columns of Nos. and a third column with the
results from the subtraction of column 1 from 2. At the bottom of each colum
I also have the resultant of the column. the display is to 0 digits but the
input on each box is to 2 digits. Also I have selected the numerical to show
in Red and parenthesis if it is a negative No. The final resultant at the
bottom of column 3 should equal 0. I cannot round to display because I would
losse the 2 digit accuracy on the input boxes.
The problem that I'm having is that the final resultant shows a negative
0. If I extend the final result to show max. digits to see why is a negative
0, somewhere around the 20th. digit numbers starts to show up instead of 0's.
Where do these numbers come from? I only inputed to 2 digits, everything else
should be 0. I cannot manipulate the formula to show positive 0 on the
result because if I make an error on the input where the answer would be
truly less than 0, it will not show it. Is there a way to change the setting
to just calculate to 2 significant digits. (Accuracy level) and again, Where
do these numbers come from?
  #2   Report Post  
Bill Martin
 
Posts: n/a
Default

Bewilder wrote:
I have created a chart with 2 columns of Nos. and a third column with the
results from the subtraction of column 1 from 2. At the bottom of each colum
I also have the resultant of the column. the display is to 0 digits but the
input on each box is to 2 digits. Also I have selected the numerical to show
in Red and parenthesis if it is a negative No. The final resultant at the
bottom of column 3 should equal 0. I cannot round to display because I would
losse the 2 digit accuracy on the input boxes.
The problem that I'm having is that the final resultant shows a negative
0. If I extend the final result to show max. digits to see why is a negative
0, somewhere around the 20th. digit numbers starts to show up instead of 0's.
Where do these numbers come from? I only inputed to 2 digits, everything else
should be 0. I cannot manipulate the formula to show positive 0 on the
result because if I make an error on the input where the answer would be
truly less than 0, it will not show it. Is there a way to change the setting
to just calculate to 2 significant digits. (Accuracy level) and again, Where
do these numbers come from?



Creating multiple posts with different names does not help. Look for responses
back at your first posting with this same question.

Bill
  #3   Report Post  
Myrna Larson
 
Posts: n/a
Default

They come from that fact that math is done in binary, and a number that has
just two decimal places in decimal probably does NOT have two decimal places
when translated to binary.

You can change the worksheet to Precision as Displayed. Maybe that will fix
things for you.

You can also round the sum: =ROUND(SUM(A1:A10),2)



On Wed, 5 Oct 2005 08:45:09 -0700, "Bewilder"
wrote:

I have created a chart with 2 columns of Nos. and a third column with the
results from the subtraction of column 1 from 2. At the bottom of each colum
I also have the resultant of the column. the display is to 0 digits but the
input on each box is to 2 digits. Also I have selected the numerical to show
in Red and parenthesis if it is a negative No. The final resultant at the
bottom of column 3 should equal 0. I cannot round to display because I would
losse the 2 digit accuracy on the input boxes.
The problem that I'm having is that the final resultant shows a negative
0. If I extend the final result to show max. digits to see why is a negative
0, somewhere around the 20th. digit numbers starts to show up instead of 0's.
Where do these numbers come from? I only inputed to 2 digits, everything else
should be 0. I cannot manipulate the formula to show positive 0 on the
result because if I make an error on the input where the answer would be
truly less than 0, it will not show it. Is there a way to change the setting
to just calculate to 2 significant digits. (Accuracy level) and again, Where
do these numbers come from?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
Opening two separate instances of Excel Ron Bishop Excel Discussion (Misc queries) 2 August 4th 05 05:30 PM
Stop Excel Rounding Dates leinad512 Excel Discussion (Misc queries) 1 April 20th 05 04:19 PM
Hints And Tips For New Posters In The Excel Newsgroups Gary Brown Excel Worksheet Functions 0 April 15th 05 05:47 PM
Excel error - Startup (and Acrobat PDFMaker) gxdata Setting up and Configuration of Excel 0 February 4th 05 04:44 AM


All times are GMT +1. The time now is 11:07 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"