MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Cannot get data to do a sum total

Posted by A.R. on October 23, 2001 10:51 AM

I received an Excel file where I need to find the sum total for a column. But the cell format is displayed as “text” so I change it to the number format. When I do an AutoSum nothing happens. I even tried to copy the data to a new worksheet and do a Paste Special and again I get no total. How do I get the data to show the sum total?

Posted by Mark W. on October 23, 2001 10:54 AM

See 2562.html (nt)