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