decimal roundoff function on worksheet tool options

  • Thread starter Thread starter dave Hislop
  • Start date Start date
D

dave Hislop

When I use the decimal roundoff on data I manually put
into my worksheet it functions perfectly. On data I get
from the internet the roundoff function is intermittant
or fails to work at all. The exact collums that would
round off manually fail when recieving information copied
and pasted from the net. My mother is the primary user of
this equipment and she uses the primary office program
editing option to cut paste and delete information on her
worksheets. Could her deleting and clearing large groups
of cells have an impact on the format or settings of the
decimal roundoff causing it to fail????? Thank
you..........................David Hislop
 
What do you mean by "is intermittant or fails to work at all"? What
actually happens? Are you using the =ROUND() or are you formatting the
cell to display fewer figures?

Absent the answers to these questions, I will guess that the problem is
that the problematic "numbers" are really text that only look like
numbers. Use =ISNUMBER(cellref) to see whether Excel thinks it is a
number or text. Reformatting the cell changes the display, not not
change the nature of the contents, so it is not sufficient to reformat
the text cells. Put a 0 in a blank cell, copy that cell, select the
offending cells and Edit|Paste Special|Add. That will convert all text
numbers to numeric numbers, which should behave as you expect.

Jerry
 
Back
Top