View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Mattlynn via OfficeKB.com Mattlynn via OfficeKB.com is offline
external usenet poster
 
Posts: 140
Default Using sum on a column I am getting ### instead of a total

That symbol normally appears if the column is not wide enough.
try widening your column where the total is.

Matt

vladtheimpaler wrote:
Hi when adding up a colum using sum instead of getting the total I am getting
###
I can see the correct answer bottom right as usual but when I try to enter
the total myself it revertts back to ### How do I get round this please?


--
Matt Lynn

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200806/1