Numbers in Excel will not add using the AutoSum ir Sum functions

		Microsoft Office Forums > Microsoft Excel > Excel
Numbers in Excel will not add using the AutoSum ir Sum functions

FAQ

Thread Tools

Display Modes

10-22-2021, 11:10 PM

Pecoflyer

Windows 7 64bit Numbers in Excel will not add using the AutoSum ir Sum functions

Office 2010

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,948

Pecoflyer has a reputation beyond repute

Quote:

Originally Posted by Nednil

A BIG THANK YOU! The problem was that the numbers were stored as text and there is a convert text to numbers under the data tab. I never thought of the numbers would be stored as text.

If you don't apply manual cell alignment , text is aligned left and numbres right, so you can see immediately what is text or not

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Know of any Excel VBA or Excel functions that can help with general lottery forecasting?	angExcelentflea	Excel Programming	6	08-11-2019 05:15 AM
give mathematic functions numbers and link in the text	Meena2287	Word	3	09-11-2015 05:38 PM
excel functions	Dotty	Excel	1	05-11-2015 03:38 PM
How to Autosum highlighted values in a table like in Excel	The_Nster	Word Tables	1	01-13-2015 01:27 PM
Excel 2010 Functions	cmf10	Excel	6	07-02-2014 08:26 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:23 PM.