WHY DO HASHES REPLACE NUMERICAL TOTAL
 

when I total 2 of my many columns I keep getting hashes instead of the total
what am I doing wrong please.

WHY DO HASHES REPLACE NUMERICAL TOTAL
 

Hi Trevor,
One possible reason is that XL uses hashes when the column is too narrow to
display a numerical value.
Try widening the column.
Regards - Dave.

WHY DO HASHES REPLACE NUMERICAL TOTAL
 

Or, if you don't want to make the column wider, make the font smaller.
--
David Biddulph

"Dave" wrote in message
...
Hi Trevor,
One possible reason is that XL uses hashes when the column is too narrow
to
display a numerical value.
Try widening the column.
Regards - Dave.

WHY DO HASHES REPLACE NUMERICAL TOTAL
 

Or even set the cell's Alignment format to "Shrink to fit".

Rick


"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
Or, if you don't want to make the column wider, make the font smaller.
--
David Biddulph

"Dave" wrote in message
...
Hi Trevor,
One possible reason is that XL uses hashes when the column is too narrow
to
display a numerical value.
Try widening the column.
Regards - Dave.