EXCEL in the auto-sum, why can not more than 12-digit identification?
can not identify what kind of situation?
EXCEL numerical accuracy of 15, more than 15 can not guarantee that numerical precision .But you are more than 12, as long as no more than 15 of the sum should be able to.
SUM function on the text of the data is automatically skip.Therefore, please check whether it is text data.
Sum if the results of Science is based on counting of the show, that the above wide enough, you can widen out a wide.
Can identify your input on the number twelve
right to choose “Format Cells”
And then the “digital” classification of “conventional” set to “value” after determining it.
To identify you enter the number 12 on the right choices
“Format Cells”
And then the “digital” classification of “conventional” set to “values” can be determined after the
Leave a Reply
You must be logged in to post a comment.