Thread: How do I add a column of numbers (auto sum)??
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme[_3_] Bernard Liengme[_3_] is offline
external usenet poster
  
Posts: 1,104
Default How do I add a column of numbers (auto sum)??
So you get something like =SUM(A1:A10) but this displays 0?
Sounds like they are not really numbers but text
Try
1) format the range as numbers
2) copy an empty cell, select the range of interest and use Edit | Paste
Special with Add specified
--this trick converts text digits to numbers most of the time
3) if all else fails, after formatting the range as numbers, retype the
numbers
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"tonysaw" wrote in message
...
When I highlight a column of numbers, I get the right formula, but return
a
value of 0??


Reply With QuoteReply With Quote