| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I remove ##### from subtotal and total rows
I am using the 12 month cash flow statement for my Quail Unlimited Chapter.
The entries show in numeric for but the subtotal and total cells all have ##### instead of numbers. If the cursor is placed on the cell the correct number shows but when removed the ##### comes back. When printing the template the ##### still show. I posted this question previously and got notification of a response but when I clicked on the link the response was blank and I could find my question on this site when I entered . Any help will be appreciated. -- JLB |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I remove ##### from subtotal and total rows
Widen your column
-- Kind regards, Niek Otten Microsoft MVP - Excel "Coveyset" wrote in message ... I am using the 12 month cash flow statement for my Quail Unlimited Chapter. The entries show in numeric for but the subtotal and total cells all have ##### instead of numbers. If the cursor is placed on the cell the correct number shows but when removed the ##### comes back. When printing the template the ##### still show. I posted this question previously and got notification of a response but when I clicked on the link the response was blank and I could find my question on this site when I entered . Any help will be appreciated. -- JLB |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I remove ##### from subtotal and total rows
Try to widen the column.
HTH Daniel I am using the 12 month cash flow statement for my Quail Unlimited Chapter. The entries show in numeric for but the subtotal and total cells all have ##### instead of numbers. If the cursor is placed on the cell the correct number shows but when removed the ##### comes back. When printing the template the ##### still show. I posted this question previously and got notification of a response but when I clicked on the link the response was blank and I could find my question on this site when I entered . Any help will be appreciated. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I remove ##### from subtotal and total rows
I am betting that your column is too narrow for what it has to display...
make the column wider. -- Rick (MVP - Excel) "Daniel.C" wrote in message ... Try to widen the column. HTH Daniel I am using the 12 month cash flow statement for my Quail Unlimited Chapter. The entries show in numeric for but the subtotal and total cells all have ##### instead of numbers. If the cursor is placed on the cell the correct number shows but when removed the ##### comes back. When printing the template the ##### still show. I posted this question previously and got notification of a response but when I clicked on the link the response was blank and I could find my question on this site when I entered . Any help will be appreciated. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I remove ##### from subtotal and total rows
Or use a smaller font (remove any bolding???)
Coveyset wrote: I am using the 12 month cash flow statement for my Quail Unlimited Chapter. The entries show in numeric for but the subtotal and total cells all have ##### instead of numbers. If the cursor is placed on the cell the correct number shows but when removed the ##### comes back. When printing the template the ##### still show. I posted this question previously and got notification of a response but when I clicked on the link the response was blank and I could find my question on this site when I entered . Any help will be appreciated. -- JLB -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002:How to remove sub total rows in Pivot Table ? | Excel Discussion (Misc queries) | |||
| can I put total value from subtotal into next column | Excel Discussion (Misc queries) | |||
| total subtotal cells | Excel Worksheet Functions | |||
| Remove Subtotal In Macro Not Working | New Users to Excel | |||
| Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
Linear Mode
