excel auto sum set up

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I use a spread sheet for my business i enter daily figures and i need to see
a month to date totals at the bottom but all i see is ####### why? and how
can i correct that?
 
harkesh said:
I use a spread sheet for my business i enter daily figures and i need to
see
a month to date totals at the bottom but all i see is ####### why? and how
can i correct that?
Click to expand...


The first thing to check is that the column is wide enough.....
 
As Gordon said, the column may simply not be wide enough to display the
results.

But if you're doing any 'math' with date/time values, Excel will also return
###### if a negative date is returned.
 
Back
Top