Have you tried widening the column. If the number is too big, it will show
up as #'s.
--
Sincerely, Michael Colvin
"TonyJag via OfficeKB.com" wrote:
I have a spreadsheet where the result of using autosum is displayed as a
single #.
Some of the cells being summed contain a 'x' but even if I chnage all these
to numerics I still end up with #.
I've tried reformatting the cells. This autosum is of 26 contiguos cells in a
row. Funny thing is autosumming the same data down a column is OK.
Any ideas folks?!
|