In Excel ### appears in the cell, not the sum. Why?

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

Guest

I am using the sum formula to sum across rows. The formula works, but for
one set of calculations the actual sum does not appear in the destination
cell, only a series of ####. How can I get the actual sum to appear? This
is only occuring for 1 set of the calculations. All others work
 
Trying increasing the column width (position your cursor up in the column
header -- on the right edge and double click... or click and drag.

Or with the column selected, go to Format -- Column Width and increase the
number until your data displays completely.

Kathryn Groves
MOUS - Office 2000
 
Back
Top