Why excel auto sum in this way out?
1.ctrl + A, Select 2, right – format cells – in the digital (pictured), the choice of conventional or numerical, can be converted in the back! !
Thanks thanks!
Is not your cell formatting, you need to adjust to digital format can be a
14 and 5, the two are text, not the numerical calculation
text format can not be calculated, will be converted to text format digital format, on it (right click – set cell – number)
Leave a Reply
You must be logged in to post a comment.