ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   why will my function not work? it is just auto sum. (https://www.excelbanter.com/excel-worksheet-functions/155513-why-will-my-function-not-work-just-auto-sum.html)

Mary needs help

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.

Michael

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.


David Biddulph[_2_]

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.





All times are GMT +1. The time now is 07:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com