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

Asked By BY on 25-Apr-07 12:46 PM
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




Kate G. replied on 25-Apr-07 12:54 PM
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