| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
why will my function not work? it is just auto sum.
All I am trying to do is use auto sum. Why does it just show the actual
function and not the answer? Thanks. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
why will my function not work? it is just auto sum.
The cell must be currently formatted as text, select Format - Cells and
choose General. Then, click on your cell and hit F2 and hit enter to refresh the formula -- If this posting was helpful, please click on the Yes button. Regards, Michael Arch. "Mary needs help" wrote: All I am trying to do is use auto sum. Why does it just show the actual function and not the answer? Thanks. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
why will my function not work? it is just auto sum.
Your cell was probably formatted as text before you entered the formula.
Format the cell as General, then go into the formula bar and confirm the formula again. -- David Biddulph "Mary needs help" <Mary needs help @discussions.microsoft.com wrote in message ... All I am trying to do is use auto sum. Why does it just show the actual function and not the answer? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto Count for Auto Filter Doesn't Function under certain circumst | Excel Discussion (Misc queries) | |||
| Auto covery won't work | Excel Discussion (Misc queries) | |||
| Will the COUNTIF function work with auto-filtering? | Excel Worksheet Functions | |||
| Is there away to keep "auto save" from jumping to the first work sheet in the work book? | New Users to Excel | |||
| Auto-fill won't work | Excel Worksheet Functions | |||
Linear Mode
