| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Giving letters a numerical value, then adding the total. | Excel Discussion (Misc queries) | |||
| Is there a quick/easy way to get excel to replace ALL forumulas the numerical result in one step? | Excel Discussion (Misc queries) | |||
| How to replace a date, change May to June keeping numerical dates | Excel Discussion (Misc queries) | |||
| How do I total non-numerical data | New Users to Excel | |||
| dates appear as error hashes | Excel Discussion (Misc queries) | |||
Linear Mode
