View Single Post
  #5   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?
i closed the file and did not save the changes and then widened the column.EUREKA!!! It worked I was able to type the right figure in. Thanks to all who replied.

Vladtheimpaler