Excel sums
 

Why do totals that are grearter than 100 get ####
How can that be changed

Excel sums
 

Try and widen the column and see if that helps
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"2141233" wrote in message
...
Why do totals that are grearter than 100 get ####
How can that be changed

Excel sums
 

Because the cell width is too small
Widen it: (a) double click the bar between the column header and the one to
the right to make an exact fit, or (b) drag the bar to make the cell wider,
or (c) select column; use Format Columns and set the width
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"2141233" wrote in message
...
Why do totals that are grearter than 100 get ####
How can that be changed