| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
excel auto sum set up
I use a spread sheet for my business i enter daily figures and i need to see
a month to date totals at the bottom but all i see is ####### why? and how can i correct that? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
excel auto sum set up
"harkesh" wrote in message
... I use a spread sheet for my business i enter daily figures and i need to see a month to date totals at the bottom but all i see is ####### why? and how can i correct that? The first thing to check is that the column is wide enough..... |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
excel auto sum set up
As Gordon said, the column may simply not be wide enough to display the
results. But if you're doing any 'math' with date/time values, Excel will also return ###### if a negative date is returned. "harkesh" wrote: I use a spread sheet for my business i enter daily figures and i need to see a month to date totals at the bottom but all i see is ####### why? and how can i correct that? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto Number the Rows of Auto Filter Result | Excel Discussion (Misc queries) | |||
| Sometimes formuli in workbook don't auto update with auto-recal on | Excel Worksheet Functions | |||
| How to AUTO SAVE as opposed to turning on auto recovery: EXCEL | Excel Discussion (Misc queries) | |||
| Auto Protecting cells & auto filling date | Excel Discussion (Misc queries) | |||
| excel links update not working in auto, calculations in auto | Excel Worksheet Functions | |||
Linear Mode
