Auto Sum

J

Jacob Skaria

Select column. Format Cells. Number..
Alt+Enter at the bottom cell

If this post helps click Yes
 
G

Gord Dibben

What happens when you try?

Might be the "numbers" are text.

Format all to General.

Select an empty cell and copy.

Select the range of "numbers" and paste special>add>ok>esc.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mass covertion from faction odds to decimal odds 4
Multiple IF Statement in Word 5
text in a vertical column - so the word reads downwards 2
Excel Auto Sum 2
Formatting question: how to format duration (time spent)? 0
Question about COUNTIFS 0
Hyperlinking automatic?? 1
Using SUM(INDIRECT()) 2

Top