WHY DO HASHES REPLACE NUMERICAL TOTAL

  • Thread starter Thread starter trevor
  • Start date Start date
T

trevor

when I total 2 of my many columns I keep getting hashes instead of the total
what am I doing wrong please.
 
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.
 
Or, if you don't want to make the column wider, make the font smaller.
 
Or even set the cell's Alignment format to "Shrink to fit".

Rick
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hash Totals 2
Total Adblocker 4
Excel VBA - counting cells by colors and names to it in two different rows. 0
summing a column gives me a date 4
Getting ### (hash) symbols in text cell instead of text 2
Currency 1
Are hash tables in Excel possible? 3
I can't see Grand total rows even though the option's switched on 2

Back
Top