View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
vladtheimpaler vladtheimpaler is offline
external usenet poster
 
Posts: 4
Default Using sum on a column I am getting ### instead of a total



"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?

Thank you unfortunately it didn't quite work . what it did was insert the
last figure to be added!
Any ideas?